SQL 2005 Management Studio Connection Guide
How to connect to your MS SQL 2005 database via SQL Management Studio Express
|
|
|
- Open SQL Server 2005 Server Management Studio Express.
- Under the "Connect to Server" popup, you will need to do the following:
- In the "Server Name" text field, type in the IP address of
your SQL server.
- Change Authentication type to "SQL Server
Authentication".
- Enter in your username and password.
- Hit the Connect button.
|
|
|
|
|
|
- If connected successfully, you should see
the IP address of your SQL server along with your login
name. All SQL Servers' IP addresses begin with
65.221.x.x.
- Expand the "Databases" directory and select your database.
You will see other users' databases on the server but will not
have access to them. This is a known issue with Microsoft SQL
Servers but does not effect the security or usability of your
database. Once you have selected your database, you should be
able to access it, thus completing the process.
|
|
|
|
|
