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 |
|
zeeshan13
Constraint Violating Yak Guru
347 Posts |
 Posted - 2007-07-23 : 14:35:04
|
| Hi All,What installing the SQL Server 2000 I provide my windows id/pwd to login to SQL Server. I not exactly remember but there is some local acess setting. How can I change the setting back to use "local access"? I dont want to re-install SQL server, but just want to change the settings.How can I do that?Any quick help will be highly appreciated.Thanks,Zee |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-23 : 15:24:16
|
| Are you referring to the SQL Server service? If so, just change the setting in the services applet. Service name for SQL Server 2000 is MSSQLSERVER or MSSQL$InstanceName.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-23 : 16:39:39
|
| Or do you mean disable remote access to sql server? |
|
|
|
zeeshan13
Constraint Violating Yak Guru
347 Posts |
Posted - 2007-07-23 : 16:56:02
|
| tkizer,I got you. Thanks :D |
|
|
|
|
|
|
Local settings for SQL server login?