Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Microsoft SQL Server, Error : 2 Expand / Collapse
Author
Message
Posted Friday, February 18, 2011 5:32 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 21, 2011 2:20 AM
Points: 2, Visits: 4
How was this error solved?
Im having the same problem! plz help
Post #1066717
Posted Friday, February 18, 2011 5:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, March 5, 2011 11:29 PM
Points: 3, Visits: 6
are you sure you have use the correct username and choose the right instance?
the instance should be like this : server name/instance
your username should be like this if you use windows au :server name /username

I solved the problem in this way ,you can have a try,make sure you have input the right ones
Post #1066719
Posted Friday, February 18, 2011 6:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 21, 2011 2:20 AM
Points: 2, Visits: 4
hi
Im not sure what 'instance' means.
Please correct what i have done wrong.
Assuming the ff.
name of my computer = HOMELAPTOP
Username= ASHH

Server type: Database Engine
Server Name: HOMELAPTOP/SQLEXPRESS
Authentication: windows authentication
Username: HOMELAPTOP\ASHH
Password: "left blank"
Post #1066730
Posted Friday, February 18, 2011 6:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, March 5, 2011 11:29 PM
Points: 3, Visits: 6
you can check your instance name by looking at the services maybe SQL service
Post #1066731
Posted Saturday, March 5, 2011 7:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, March 5, 2011 7:27 PM
Points: 1, Visits: 0
It should be back slash: SQL Server Name\instance
To find instance name:
Click on Start> Programs > MS SQL ..2008 > Configuration Tools > SQL Server C.. Manager > SQL Services and the instance is SQL Server (MSSQLSERVER) so if you didnt make any changes during the instalation MS names it MSSQLSERVER.
Post #1073791
Posted Wednesday, March 16, 2011 1:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 21, 2011 7:49 PM
Points: 7, Visits: 42
Check if all the Services are running in sql server configuration manager
check the protocols if they are enabled.
Nike air pas cher
nike shox pas cher
Post #1078815
Posted Wednesday, March 20, 2013 10:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 2, 2013 5:41 AM
Points: 1, Visits: 6
Thank you Guys, i was facing same pbm, Fixed it now.

Used Following steps:

Goto Run -> services.msc -> enable all sql services

thats it guys...

And dont forgot to enter correct username, password and server name.
Post #1433582
Posted Saturday, May 25, 2013 3:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 24, 2013 3:14 AM
Points: 1, Visits: 2
hello .. it shows me an error to SQL Server Services. how can i fix it?
Post #1456777
Posted Wednesday, May 29, 2013 7:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 20, 2014 10:38 PM
Points: 1, Visits: 54
What is the error?
Post #1457730
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse