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 |
raju2647
Starting Member
22 Posts |
Posted - 2005-12-30 : 01:18:33
|
hi when i try to drop a linked server error is showing like"There are still remote logins for the server ".can anyone help me with the following doubts...1)how can i set specific username and password for a linked server ie when i click on the linked server in the enterprise manager security tab it should ask for username and password.2)the linked server when expanded shows tables from all the database in the linked server and not the specific database i have connected.can i set it for a particular database inside the server.3)can anyone explain what is "DRIVER={SQL Server};" in the provider stringregardsraju |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-30 : 05:40:53
|
cross posthttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=596721. After you setup your client network utlity and register your server in EM, choose, always prompt for username and password while connecting2. Dont really understand, but if its to register a remote server and connect to it, then YES !3. see www.connectionstrings.com hope this helps |
|
|
|
|
|