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 |
|
DavidI
Starting Member
2 Posts |
 Posted - 2007-09-11 : 13:17:05
|
| Please forgive my ignorance, I am by no means a SQL Expert, but have encountered a strange issue.I have 6 SQL Servers, Primarily SQL 2005 (one older SQL 2000) all loaded on Windows Server 2003 SP1.We use the servers for a proprietary database that we created which is the backend to a software package we sell.The issue I have is: We have added a Security account to the servers, and in one case we have granted rights for this account to the TempDB system database. However, whenever we restart this server SQL drops this user account, thus severing connectivity for the app that is relying on that account.I have set the account as DB-Owner etc, but nothing sems to keep it on re-start.Any input would be greatly appreciated. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-09-11 : 16:40:34
|
| the tempdb gets dropped & recreated when you stop/start the SQL Server.Why are you granting permissions on the tempdb to a user anyway? Are you creating objects explicitely in the tempdb? -ec |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-11 : 16:47:17
|
| You can add the accounts to the model database to fix the issue. Model is used as the template for new databases. Tempdb is a new database every time SQL Server starts.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
DavidI
Starting Member
2 Posts |
Posted - 2007-09-11 : 16:49:23
|
| Well now, that would make complete sense then woulnd't it...For some reason our developer uses that database for authentication into a web based app he created.Now that I know what is going on, I am going to see if he can't do it a different way.Thank you very much for your input. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-11 : 16:50:46
|
| What the developer is doing is absurd. Users should authenticate to the server and then access only the database where the objects exist.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
TempDb drops user account on server restart?