Remote Connection MSSQL
-
Hi.. I have been assigned to make a database in some remote machine.The machine has MSSQL 2005.I need to connect to that remote machine's sql server via my pc using my SQL Management express.I do have that computer's IP address(say,123.456.789.000),and the username and password.But when i try to connect to the server ,I get the following error: Cannot connect to 123.456.789.000\sqlexpress An error has occured while establishing a connection to the server.When connecting to SQL server 2005,this failure may be caused by the fact that unser the default settings SQL server does not allow remote connections,(provider:SQL Network Interfaces,error:26-Error Locating Server/Instance specified)(Microsoft SQL Server) I am a new programmer and dont know much.But i guess the problem is not in my server but in that server to which i am trying to connect.I guess that server has some instance created or it does not allow remote connections.But i am not sure.Is it so?Or is anything wrong in my server.Any ideas? Thanks confused
-
Hi.. I have been assigned to make a database in some remote machine.The machine has MSSQL 2005.I need to connect to that remote machine's sql server via my pc using my SQL Management express.I do have that computer's IP address(say,123.456.789.000),and the username and password.But when i try to connect to the server ,I get the following error: Cannot connect to 123.456.789.000\sqlexpress An error has occured while establishing a connection to the server.When connecting to SQL server 2005,this failure may be caused by the fact that unser the default settings SQL server does not allow remote connections,(provider:SQL Network Interfaces,error:26-Error Locating Server/Instance specified)(Microsoft SQL Server) I am a new programmer and dont know much.But i guess the problem is not in my server but in that server to which i am trying to connect.I guess that server has some instance created or it does not allow remote connections.But i am not sure.Is it so?Or is anything wrong in my server.Any ideas? Thanks confused
I too had same issue like this I installed SQL Server SE, on an XP machine. How other users of same domain can access SQL server using SQL Server Express Edn. I did create new logins for user, windows authentication. But whenever user try to connect it show message like 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: SQL Network Interfaces, error: 26 - Error locating Server/Instance Specified). How to get rid of this issue. Do i need to set/change in WInodws user accounts?
-
Hi.. I have been assigned to make a database in some remote machine.The machine has MSSQL 2005.I need to connect to that remote machine's sql server via my pc using my SQL Management express.I do have that computer's IP address(say,123.456.789.000),and the username and password.But when i try to connect to the server ,I get the following error: Cannot connect to 123.456.789.000\sqlexpress An error has occured while establishing a connection to the server.When connecting to SQL server 2005,this failure may be caused by the fact that unser the default settings SQL server does not allow remote connections,(provider:SQL Network Interfaces,error:26-Error Locating Server/Instance specified)(Microsoft SQL Server) I am a new programmer and dont know much.But i guess the problem is not in my server but in that server to which i am trying to connect.I guess that server has some instance created or it does not allow remote connections.But i am not sure.Is it so?Or is anything wrong in my server.Any ideas? Thanks confused
-
Hi.. I have been assigned to make a database in some remote machine.The machine has MSSQL 2005.I need to connect to that remote machine's sql server via my pc using my SQL Management express.I do have that computer's IP address(say,123.456.789.000),and the username and password.But when i try to connect to the server ,I get the following error: Cannot connect to 123.456.789.000\sqlexpress An error has occured while establishing a connection to the server.When connecting to SQL server 2005,this failure may be caused by the fact that unser the default settings SQL server does not allow remote connections,(provider:SQL Network Interfaces,error:26-Error Locating Server/Instance specified)(Microsoft SQL Server) I am a new programmer and dont know much.But i guess the problem is not in my server but in that server to which i am trying to connect.I guess that server has some instance created or it does not allow remote connections.But i am not sure.Is it so?Or is anything wrong in my server.Any ideas? Thanks confused
Contact the DBA responsible for the server and ask them to use SQL Server Surface Area Configuration tool to check whether SQL Server is configured to allow remote connections.
-
I could login from the local machine. When when other user try to login it show error. It seems that Windows Authentication issues are there. What all things to do in the SQL Ser. Standard Edition ( XP ) to enable remote login ( like user permission, adding new login , etc etc )
-
Contact the DBA responsible for the server and ask them to use SQL Server Surface Area Configuration tool to check whether SQL Server is configured to allow remote connections.
Its enabled
-
Its enabled
Is SQL Browser service running?
-
Is SQL Browser service running?
Hi..yes the remote server is up and the sql browser service in my local server is running.Any other configurations i need to check? confused
-
Hi..yes the remote server is up and the sql browser service in my local server is running.Any other configurations i need to check? confused
Check firewall on the client and server.
-
Hi.. I have been assigned to make a database in some remote machine.The machine has MSSQL 2005.I need to connect to that remote machine's sql server via my pc using my SQL Management express.I do have that computer's IP address(say,123.456.789.000),and the username and password.But when i try to connect to the server ,I get the following error: Cannot connect to 123.456.789.000\sqlexpress An error has occured while establishing a connection to the server.When connecting to SQL server 2005,this failure may be caused by the fact that unser the default settings SQL server does not allow remote connections,(provider:SQL Network Interfaces,error:26-Error Locating Server/Instance specified)(Microsoft SQL Server) I am a new programmer and dont know much.But i guess the problem is not in my server but in that server to which i am trying to connect.I guess that server has some instance created or it does not allow remote connections.But i am not sure.Is it so?Or is anything wrong in my server.Any ideas? Thanks confused
-
Check firewall on the client and server.
Hi thanks ... Well...I am afraid I dont know about the firewall state in the computer that i am tring to accesss...I will surely find that out ASAP...abt my station ,yes ,the firewall is on but i have defined SQL server and the SQL browser as exceptions for it .That means firewall must not block these applications. confused
-
Hi thanks ... Well...I am afraid I dont know about the firewall state in the computer that i am tring to accesss...I will surely find that out ASAP...abt my station ,yes ,the firewall is on but i have defined SQL server and the SQL browser as exceptions for it .That means firewall must not block these applications. confused
-
Thanks everyone!! I solved the problem.Well..the mistake was quite simple.I had been giving the hostname as hostname\sqlexpress but it shud have been only hostname. Rest everything was working fine. Cheers! confused -- modified at 5:22 Friday 5th October, 2007 confused