Date: Tue, 1 Jul 2003 16:41:37 -0700
Did you add the group permissions today in SQL? If so,
did the restore take them out??
Ray Higdon MCSE, MCDBA, CCNA
>SQL 2000, windows 2000
>I am using window NT authentication. In SQL Server, I
>permission to NT group GROUP1. My NT login USER1 is the
>member of GROUP1.
>Get error when set up ODBC : Connection failed, sQL
>42000, SQl server error 4064. Can not open user default
>database. login failed.
>If I give permission to USER1 directly, It works.
>all SQL server login works.
>By the way, it worked before and not work after I
>last night backup data. No change with user or any NT
- RE: Trying to RESTORE a sql 2000 db on a different drive letter.
... During the installation of sql server, if you did not pick the d: ... the data drive or the system files drives, it will not have the necessary ... Right click on the database you want to restore. ...
- Re: SQL backup questions
... I support the Professional Association for SQL Server ... Copy DB is functionally the same as Backup and Restore. ...
- Re: SQLDUMPER library error message (PLEASE HELP)
... I ran services.msc and disabelled SQL Server VSS ... >>> Accounting 2007, a new program that I do not even know when or why I ... >> an MS Office 2007 trial - or do a System Restore. ... you'll see an entry made just ...
- Re: Migration ?
... I've tried every way I can think of trying to restore the master database. ... Will a restore on the SQL ... Install a SQL Server failover cluster instance ...
- Re: Migration ?
... During a restore, all of the metadata is upgraded. ... Moving the Master and MSDB database, what if the old server where those ... Will a restore on the SQL ... Install a SQL Server failover cluster instance ...