Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
 Posted - 2010-08-10 : 10:55:39
|
| HiHow do I create a local database server.I previousl had the local database but not now after reinstalltion of the SQL server 2008 I am able to connect to differant Sql servers to which i have access to using my windows authentication and when Iam trying to connect to my local machine sql server Iam getting an error which says my userid is not authenticatedPlease help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-10 : 13:44:58
|
| have you added login corresponding to your userid in local server? have you tried accessing it using sa?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
Posted - 2010-08-11 : 10:48:42
|
| Nope I did not add myuserid in local server - How do i do that?how do i use sa accountThanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-11 : 10:52:23
|
| http://msdn.microsoft.com/en-us/library/aa337562.aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
Posted - 2010-08-11 : 11:03:22
|
| Hi VisakhIam unable to connect to my local database itself,So not usre how can i create a new loginI freshly installed sqlserver 2008 and when trying to connect to the database engine that is on my local machine with my windows authentication it wont let me do thatMicrosoft Sql server error 18456 |
|
|
|
|
|
|
Local Database Server