Connecting to SQL database using SQL Enterprise Manager

Problem:

Connecting to SQL database using SQL Enterprise Manager



Solution:

Please follow the steps below:
 
STEP 1: Open the SQL Server Client Network Utililty
 
 Start Programs Microsoft SQL Server  Client Network Utility
 
STEP 2: Click on the "Alias" tab
 
STEP 3: Click "Add" and enter the following information
 
Server Alias  SQL
Network Library  TCP/IP
Computer Name  SQL.ITSOUL.COM
Port Number  1433
 
STEP 4: Click OK
 
STEP 5: Click OK
 
This will close out the Client Network Utility
 
STEP 6: Open Enterprise Manager
 
 Open Enterprise Manager  Right Click "Microsoft SQL Servers"   Select "New SQL Server Registration" This will open a wizard  Click Next.
 
STEP 7: Select "SQL" Database
 
Select "SQL" from the list of available servers and "Add" it. Click Next.
 
STEP 8: SQL Server Authentication
 
Choose to connect using SQL Server Authentication.
 
STEP 9: Enter your username and password
 
Enter your assigned username and password. Keep on clicking next until the wizard is completed.
 
STEP 10 : Help ! If nothing works try this
 
Sometimes understanding a HOW TO could be confusing process and If you have any questions or experience any difficulty, please send us a support ticket & we'll help you through it as best we can.
 
Click here to send us a ticket Now.
  • 0 Пользователи нашли это полезным
Помог ли вам данный ответ?

Связанные статьи

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

Problem: get "SQL Server does not exist or access is denied" error when I tried to connect to MS...

Connecting to MSSQL with out a DSN

Problem: Connecting to MSSQL with out a DSN Solution: * You can use the following string...

Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes a Long Time

Problem: Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes a Long Time...

I'm getting a strange error message: Operation must use an updateable query(error '80004005')?

Problem: I'm getting a strange error message: Operation must use an updateable query(error...

error: Too few parameters

Problem: error: Too few parameters Solution: error type:Microsoft OLE DB Provider for ODBC...