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 |
|
elic05
Yak Posting Veteran
62 Posts |
 Posted - 2009-01-07 : 13:11:18
|
| My site use a db that was created using the membership schema. I added additional tables to this db.localy everything worked fine.I deployed the site to a remote server.I used Microsoft SQL Server Management Studio Express to run a scrip i created from the original db (The script was created using Microsoft SQL Server Database Publishing Wizard), this script created the db including its data on the server.My problem:I cant register users, I cant login (although I see the names listed in the tables on the servers)every action that has to communicate with the aspnet tables is not workin.Maybe there are permmision i have to define. |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2009-01-07 : 13:42:35
|
| Likely reason for the login failure is that the new server does not have logins for your users. You can check this in SSMS Object Explorer by going to the Security->Logins under the server (Not under the database>Database Name>Security).This web page describes the steps you need to take to port users and passwords from one server to another and between various versions of SQL.http://support.microsoft.com/default.aspx?scid=kb;en-us;246133I have used the procedure outlined there for moving users who were using SQL authentication from SQL 2000 to SQL 2005 server. If you are using windows authentication, the procedure may be different, not sure if that page covers that also. |
 |
|
|
elic05
Yak Posting Veteran
62 Posts |
Posted - 2009-01-07 : 15:17:07
|
| If that is the problem why cant I register a new user? |
|
|
|
|
|
|
uploadind a DB to a remote server