How to use SQL Management Studio Express 2005?

Open your SQL Management Studio Express 2005 on your local machine.

Step 1) Type the ServerName: eg: sknet74.seekdotnet.com,25000
Step 2) Choose SQL Server authentication
Step 3) Login Name: C1000_DBUserName
Step 4) Password:DBPassword
Step 5) Click OK and wait for the database to be connected

Was dit antwoord nuttig?

 Print dit artikel

Lees ook

I get "SQL Server does not exist or access is denied" error when I tried to connect to MS SQL database on your server?

This error indicates that Enterprise Manager or Query Analyzer cannot make a connection the...

How to transfer SQL database from My Database Server to your Database Server

From the Start Menu, select Programs -> Microsoft SQL Server -> Import and...

How can i generate scripts for MS SQL Database?

Your default database user don't have privillages to do that You can just create a support...

I am able to view and access a SQL database other than my own while connected with Enterprise Manager, Query Analyzer, or the SQL Web admin. What is wrong?

This happens because the customer has added Guest Access/Public to their SQL...

I get "The server principal "username" is not able to access the database "databasename" under the current security context. (Microsoft SQL Server, Error: 916) " after I tried to login via MS SQL Management Studio?

To fix this SQL Server Management Studio 2008 bug please do the following: Open SQL Server...