Remote Connection MSSQL Express2005
-
Hi All, I have developed an application in vb.net 2005/ Mssql express 2005. It works very fine on my machine, but give me problem when i am trying to run it on my remote machine. I am using LAN (Cross over Cable). It gives me an error "Login failed for user 'MyServerName\Guest' when i am trying to run it on my remote machine. My Connection String is like following. Conn = New SqlConnection("Server=myserver\SQLEXPRESS,1028;Trusted_Connection=yes;database=mydatabase") I have done following steps. Sql Server 2005 Surface Area Configuration. I have set Remote Connections Local and Remote Connections. Using Both TCP/IP and Named Pipes. Apply Done. Stop Service and again restart. Sql Server Configuration Manager Sql Server 2005 Network Configuration Protocols for SqlExpress Shared memory = Enabled Named Pipes = Enabled TCP/IP = Enabled Via = Enabled Sql Server 2005 Services Sql Server (SqlExpress) Running. Sql Server Browser Running. Stop and again restart. Ms Sql Server Management Studio SqlExpress. Set Security to Sql Server and windows Authentication mode. But still i am facing the same problem. Kindly help me. Thanks in advance.
rmshah Developer
-
Hi All, I have developed an application in vb.net 2005/ Mssql express 2005. It works very fine on my machine, but give me problem when i am trying to run it on my remote machine. I am using LAN (Cross over Cable). It gives me an error "Login failed for user 'MyServerName\Guest' when i am trying to run it on my remote machine. My Connection String is like following. Conn = New SqlConnection("Server=myserver\SQLEXPRESS,1028;Trusted_Connection=yes;database=mydatabase") I have done following steps. Sql Server 2005 Surface Area Configuration. I have set Remote Connections Local and Remote Connections. Using Both TCP/IP and Named Pipes. Apply Done. Stop Service and again restart. Sql Server Configuration Manager Sql Server 2005 Network Configuration Protocols for SqlExpress Shared memory = Enabled Named Pipes = Enabled TCP/IP = Enabled Via = Enabled Sql Server 2005 Services Sql Server (SqlExpress) Running. Sql Server Browser Running. Stop and again restart. Ms Sql Server Management Studio SqlExpress. Set Security to Sql Server and windows Authentication mode. But still i am facing the same problem. Kindly help me. Thanks in advance.
rmshah Developer
Since you're using trusted connection, do you belong to a windows group that has access to that SQL Server and to that database or do you have that access granted to you personally? Now it seems that you're not granted the access so SQL Server uses Guest account which then again doesn't have access to the SQL Server instance.
The need to optimize rises from a bad design.My articles[^]