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 |
|
thermalnoise
Starting Member
7 Posts |
 Posted - 2006-04-07 : 10:24:48
|
| I have an interesting dilemma trying to setup a new database (SqlServer 2000) and add the ASPNET user to it.Background: My PC was renamed a few months ago, after SqlServer was installed and the first database set up. So, I have a user in my Logins called (I'm using examples here) ORIGINAL\ASPNET. This account is a user for FIRSTDB. Everything worked great, and even after my PC was renamed, it has still worked without any problems.Today, I went to add a new database, SECONDDB. I went to the users tab, selected New User.. and in my Login name dropdown, ORIGINAL\ASPNET is an option. If I select ORIGINAL\ASPNET and then click OK, I get the following error:Error 15401: Windows NT user or gropu 'ORIGINAL\ASPNET' not found. Check the name again.So then I tried going to Security -> Logins, and adding a new Login. By the name box I opened the New Login dialog box, and selected NEWPCNAME from the "List Names From" dropdown. I see the ASPNET account listed under the Names and select it, click Add, and then OK. I keep Windows Authentication and Grant Access selected, then click OK. Same error pops up:Error 15401: Windows NT user or gropu 'NEWPCNAME\ASPNET' not found. Check the name again.My network admins aren't any help here. Any suggestions? |
|
|
birtap
Starting Member
1 Post |
|
|
thermalnoise
Starting Member
7 Posts |
Posted - 2006-04-07 : 13:07:40
|
| Thank you. I was able to fix my problem by deleting the original Login account and adding the new one. |
 |
|
|
|
|
|
|
|
ASPNET Account