how to access Database from sql server of another computer ?

[vidhyaG]

Hi.....

we are 5 members working in same project.we are using sql server 2005.so we have to share one database.how to do that?how to connect sqlserver from another computer?

[Christopher Nigro]

When you say "Connect", do you mean connect from Management Studio or do you mean connect programatically with some sort of connection object in code?

From Management Studio, you just choose Connect\Database Engine from the Object Explorer and enter in the server name and authentication mode/credentials.

If you are talking about a connection object, you should post in the forum related to your platform.

[vidhyaG]

@Christopher Nigro
Thanks for Replying...

I want to connect sqlserver of another system from my sqlserver Management Studio.

I tried following Steps..

1)in sqlserver surface area configuration i enabled local and remote connection
2)restarted database engine
3)enabled sql browser in sql configuration manager
i did that in two systems
then i did
4)tried to connect sqlserver of another system from my system
sqlserver management studio->object explorer->connect->gave sql server name of another system->connect
but i did not work successfully....

Error:
cannot connect to nexus1

A network related or instance specific error occurred while establishing a connection to server.the server was not found or not accessible.verify instance name is correct and that sql is configured to allow remote connections


Please help me...

[Christopher Nigro]

Did you verify that the instance name from the SQL server that you are trying to connect to was the same as the name you entered? In the Server Name list, click <browse for more> and see if it shows up. Is the SQL Server in your environment/domain?

[vidhyaG]

@Christopher Nigro
ya.you are correct.... instance name is not there...

but i tried to browse..in that also system name is only there...then i typed ownly (Ex).Nexus1\SQLEXPRESS

but same error is coming..

then tried with another server which have correct name with instance...

but that also not working...

another error came...

ERROR:Login failed for user ".the user is not associated with a trusted sql server connection..(Microsoft sql server Error:18452)

Note :in security option windows authentication is enabled.

[Jerry Winston]

Here's a few hot-spots to check:

1. Ensure all users are in the same domain
2. Check the CONNECT rights granted to domain group containing the 5 developer logins.
3. Make sure you have enabled your network protocols e.g. TCP/IP, Shared Memory, ect from inside SQL Server Configuration Manager.
4. Make sure your firewall is not blocking SQL Server ports 1433. (1434)

Try this:
1. Change the security mode to Mixed mode.(restart the SQL server)
2. Create a new SQL login and map it to the common database.
3. Grant the new login connect rights to the server.
4. Login using the IP address of the server and instance name 123.1.2.123\SQLEXPRESS and the new SQL login.

[Bala Krishnan]

Just add a port in your firewall

add exception:

name : sql
port : 1433


or simply turn off fire wall