why i cannot login to my sql server 2005?
-
i don know why i cannot login to sql server 2005 after create an file Access connect to sql server? it show message when login "TITLE: Connect to Server ------------------------------ Cannot connect to SOKHENG. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061) ------------------------------ but if i change server name from "Sokheng" to "Sokheng\SQLEXPRESS" it can login, but i found my database name in that. do anybody kno why ? please show me some guid line .......
-
i don know why i cannot login to sql server 2005 after create an file Access connect to sql server? it show message when login "TITLE: Connect to Server ------------------------------ Cannot connect to SOKHENG. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061) ------------------------------ but if i change server name from "Sokheng" to "Sokheng\SQLEXPRESS" it can login, but i found my database name in that. do anybody kno why ? please show me some guid line .......
xingselex wrote:
but if i change server name from "Sokheng" to "Sokheng\SQLEXPRESS" it can login,
"Sokheng" isn't the name of the server, but the name of the computer on which the server is installed. The name of the server-instance is "SQLEXPRESS". You'll need to specify both in order to connect. You can substitute the PC-name for an IP-address, if you want;
127.0.0.1\SQLEXPRESS
You can specify the name of the instance during the installation of SQL Server. Good luck :)
I are troll :)