Need Help, How I Restore Login(SQL)

Need Help, How I Restore Login(SQL)

Post by Libe » Wed, 24 Feb 1999 04:00:00



Hello :
I  have restoring my Database, but I don't know  How I restore my
login(Users) of my
Sql Server .I have Sql Server 6.5.

Thank for you help

Liliana Bravo

International Potato Center

 
 
 

Need Help, How I Restore Login(SQL)

Post by M Tjade » Wed, 24 Feb 1999 04:00:00


Maybe "sp_change_users_login" can help you.

/MT

>Hello :
>I  have restoring my Database, but I don't know  How I restore my
>login(Users) of my
>Sql Server .I have Sql Server 6.5.

>Thank for you help

>Liliana Bravo

>International Potato Center


 
 
 

Need Help, How I Restore Login(SQL)

Post by Steven Cardina » Wed, 24 Feb 1999 04:00:00


Your logins are stored in the master database.  The users are stored IN the
database.  Which are you restoring?

-Steve


>Hello :
>I  have restoring my Database, but I don't know  How I restore my
>login(Users) of my
>Sql Server .I have Sql Server 6.5.

>Thank for you help

>Liliana Bravo

>International Potato Center

 
 
 

1. begginner needs help with error - OLE DB Provider for SQL Server (0x80004005) Login failed

hi all

i installed a clean sql server 2000
did not change anything.
then i installed .NET - again - did not change anything.

then i tried running a simple code accessing sql server.

but i get this error:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server
connection.
/WebApplication1/4885-all/Chapter01/DataGrid.asp, line 9

here is the problematic line (line 9):
rs.Open "select * from authors", "Provider=SQLOLEDB; Data Source=.; Initial
Catalog=pubs; UID=sa; PWD="

please anyone help me
what must i do in sql server to make a simple asp page access it?

thank you in advance

assaf wodeslavsky
web programming lecturer
tel aviv yafo academy
israel

2. wild card search

3. new to TS and to SQL ...need login help

4. mvBASE Printing

5. Help: restoring user - login link on standby database

6. Back up

7. Help! Need to restore to personal sql

8. Ingres Superusers have access to all groups

9. SQL 2000 Restoring Database Problem Need Help Please!!

10. need help restoring SQL Server

11. Help, my SQL server crashed...need to restore

12. Help: Help: Help SQL Server Login Dialog appears!!!!!!!