SQL server 2008 connection problem..need help FAST!!?

Posted by Somay1992 under Sql Server on 2/8/2014 | Points: 10 | Views : 777 | Status : [Member] | Replies : 2
hello,i am sort of new to SQL server mgmt studio...i installed the mgmt studio quite well..but i am unable to connect to the server..i get various errors..
i tried this method: Start => Control Pane => Open Administrative Tools => Data Sources (ODBC)

u get window with tabs

Go Tab - User DSN => Click on ADD => opened window => Create New Data Source => SQL Native Client or SQL Server => Finish

You find New Window Create New Data Source To SQL Server
Name = SQLEXPRESS
Description = SQLEXPRESS
select Server or type the name of Server with correct path
Server = COMP1\SQLEXPRESS (your computer name \ SQLEXPRESS)

Click on Next => On next window you have choose Window or Server Authentication and click on Next
Now you have find new window with Change Default Database and Attach Database FileName, if you want to chand default db then click and change. go to Next
On next window you just click on Finish and see the Magic you have find your connectivity.

Test the Data Source
Microsoft SQL Native Client Version 09.00.1399
Running connectivity tests...
Attempting connection
Connection established
Verifying option settings
Disconnecting from server
TESTS COMPLETED SUCCESSFULLY! "

this did happen only once,but when i tried it again it failed!
i am getting error number 26 and 87..
please help..i need it today only!




Responses

Posted by: Sravan661 on: 2/10/2014 [Member] Bronze | Points: 25

Up
0
Down
Hi,
Please verify your installation
http://www.codeproject.com/Articles/305113/How-to-Install-SQL-server-2008-on-Windows-7
Revert if not solved with your system Configuration

Mark as answer if you are satisfied

sravan

Somay1992, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 2/10/2014 [Member] [MVP] Platinum | Points: 25

Up
0
Down
first check whether u r able to login to sql server instance using sql server management studio....
use the below links for that. if u r getting any error means post us error message back . we will provide u the way to sort out issue...

http://www.andrewcomeau.com/Articles/beginning-sql-server3.aspx
http://www.andrewcomeau.com/Articles/beginning-sql-server3.aspx
http://technet.microsoft.com/en-us/library/ms365247(v=sql.105).aspx

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Somay1992, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response