SQL Server does not exist or access denied
-
Hey guys, strange problem... when connecting to SQL Server (2000) from my WinXp (sp2) machine, i get a 'SQL Server does not exist or access denied' exception. However, when i browse to the server in the server explorer (the SQL server runs on a diffrent machine) i CAN access the server. So I dragged and dropped the connection onto my (web) form and tried to open it at Page_Load() (ASP.NET) Same problem. I know for sure my connection string is correct, I don't use integrated security, but log on with the 'sa' user and it's password. I know this user has enough rights, because I can browse the entire database needed using the server explorer as well as the enterprise manager. I think my winxp firewall blocks something, or the aspnet user (which runs the worker proces (aspnet_wp) for my website) hasn't got enough rights for network communication or so. I tried disabeling the winxp firewall without success, i'm pretty much out of solutions... anybody had this before, or knows what's going on? Thnx in advance, Eduard
-
Hey guys, strange problem... when connecting to SQL Server (2000) from my WinXp (sp2) machine, i get a 'SQL Server does not exist or access denied' exception. However, when i browse to the server in the server explorer (the SQL server runs on a diffrent machine) i CAN access the server. So I dragged and dropped the connection onto my (web) form and tried to open it at Page_Load() (ASP.NET) Same problem. I know for sure my connection string is correct, I don't use integrated security, but log on with the 'sa' user and it's password. I know this user has enough rights, because I can browse the entire database needed using the server explorer as well as the enterprise manager. I think my winxp firewall blocks something, or the aspnet user (which runs the worker proces (aspnet_wp) for my website) hasn't got enough rights for network communication or so. I tried disabeling the winxp firewall without success, i'm pretty much out of solutions... anybody had this before, or knows what's going on? Thnx in advance, Eduard
Just a thought, but have you tried going to the "Security" in the Enterprise Manager tree and setting or even creating the ASPNET user account, with all the correct privilages. I had that problem before and it turns out that I had to redo that for every new project/database. Happy New Year! Ironsmith
-
Just a thought, but have you tried going to the "Security" in the Enterprise Manager tree and setting or even creating the ASPNET user account, with all the correct privilages. I had that problem before and it turns out that I had to redo that for every new project/database. Happy New Year! Ironsmith
Checked my security setting, I'm DB Owner for that database. Should be enough right? My current code Try objConn.ConnectionString = "Data Source=192.168.0.1;Initial Catalog=Website;User Id=sa; Password=password;" objConn.Open() Label1.Text = "OK" Catch ex As Exception Label1.Text = ex.Message End Try Should be OK. I've got only one instance of sql server running, so that shouldn't be the problem. I tried creating a regular windows app. which runs under my local user, and still no result. At least this solved the ASPNET User Account issue. Even if I copy the connection string from the connection in my Server Explorer there's no result.. But i'm pretty sure my connectionstring is right... I know using the 'sa' user isn't a good idea in production websites, but for testing issues, i know the user has enough access rights for sure, that's why using sa at this time. Happy new year to you too! I love it when a plan comes together
-
Checked my security setting, I'm DB Owner for that database. Should be enough right? My current code Try objConn.ConnectionString = "Data Source=192.168.0.1;Initial Catalog=Website;User Id=sa; Password=password;" objConn.Open() Label1.Text = "OK" Catch ex As Exception Label1.Text = ex.Message End Try Should be OK. I've got only one instance of sql server running, so that shouldn't be the problem. I tried creating a regular windows app. which runs under my local user, and still no result. At least this solved the ASPNET User Account issue. Even if I copy the connection string from the connection in my Server Explorer there's no result.. But i'm pretty sure my connectionstring is right... I know using the 'sa' user isn't a good idea in production websites, but for testing issues, i know the user has enough access rights for sure, that's why using sa at this time. Happy new year to you too! I love it when a plan comes together
Do you also have Reading and Writing privilages set? And if your unsure about your connectionstring then just drag the database from Server Explorer onto the form, it'll automatically create the sqlConnection1 with the correct connectionstring. Cheers Ironsmith
-
Do you also have Reading and Writing privilages set? And if your unsure about your connectionstring then just drag the database from Server Explorer onto the form, it'll automatically create the sqlConnection1 with the correct connectionstring. Cheers Ironsmith
in fact, I did that. The server explorer opens the connection successfully, but the web-form doesn't. Same error. I love it when a plan comes together