Help I got a problem when I try to connect to a database

Administrator

23y2.1k.NET

I got a weird problem that I hope can be fixed. Im creating an ASP.Net page which will allow users to create a game account for a Game Server that I'm planning to build within the following year. The game accounts will be stored on a database on my computer. I have already written a windows version of the Account manager which allows people to create/edit/or get a password reminder. The problem is that when I try to open an sqlConnection it gives the following error System.Data.SqlClient.SqlException: Login failed for user 'BRANDON\ASPNET'. at System.Data.SqlClient.SqlConection.Open() ... The connection strings for the windows version and the ASP.NET version are identical so what could be the problem. Here is what the connection string is for both versions this.m_sqlConnection.ConnectionString = "data source=(local)\\NetSDK;initial catalog=Game Server;integrated security=SSPI;persist security info=False;workstation id=BRANDON;packet size=4096"; Does anyone have any idea what could be causing this problem?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Administrator23y ago
Your advice worked Amid thanks for the help. I was getting pretty mad cause I had the problem for 2 days straight and I just started ASP.NET programming 3 days ago.
+1
Administrator23y ago
It doesn't matter whether your program runs on the local computer or the remote one. Configue SQL Server using SQL Server Enterprise Manager. Check rights for the user BRANDON\ASPNET. There is good sample called IBuySpy (http://samples.gotdotnet.com/quickstart/aspplus/doc/ibuyspy.aspx) there you can find how to configure datbase.
+1
Administrator23y ago
This program is being run on my local computer, and I created the Database using the tools in Visual Studio .Net. So do you have any clue on how I could configure the Sql Server? Any help would be appreciated.
+1
Administrator23y ago
When you access database from your asp.net application you act under the ASPNET account (not like in the windows forms app). So probably ASPNET account on your server doesn't have sufficient permissions to access the desired database. Try to configure SQL Server to give needed rights to ASPNET account. Hope this helps:)
+1