Posted by DanWeaver on 02/15/07 05:51

Thanks, Erland. Something fishy was ocurring with the dbs- deleted
them and reconnected and set permissions again- seems to work now.

Cheers, more challenging questions (when I am more informed!) will
probably follow.

Dan

> Seems like that either your user is not present in the pubs database,
> or the database has somehow gone away.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Merging contents of one db to another huge db.
• Prev in forum: Re: Backup and restore database hourly: how to implement it?
• Thread view: Re: Can't Connect to SQL db

[Reply to this message]