Connection failed to local SQL server

Hello,
One day when i try to open my database om my local computer (Win 2000
server, SQL 2000 EE, sp3) i get message:
A connection could not be established to (LOCAL)
Reason: cannot open user default database. Login faied..
Please verify SQL Server is running and check your SQL Server
registration properties (by right-clicking on the (LOCAL) node) and try again.
SQL Server is running and right-clicking produces just the same message.
Can anybody say what happend and what to do.
Thanks a lot.1. check which database is default database for your login
2. default database exist on server?
3. check permissons on your default database
"olsh" wrote:
> Hello,
> One day when i try to open my database om my local computer (Win 2000
> server, SQL 2000 EE, sp3) i get message:
> A connection could not be established to (LOCAL)
> Reason: cannot open user default database. Login faied..
> Please verify SQL Server is running and check your SQL Server
> registration properties (by right-clicking on the (LOCAL) node) and try again.
> SQL Server is running and right-clicking produces just the same message.
> Can anybody say what happend and what to do.
> Thanks a lot.|||Sorry, how can i check these if i have no access to SQL Server?
"Aleksandar Grbic" wrote:
> 1. check which database is default database for your login
> 2. default database exist on server?
> 3. check permissons on your default database
>
> "olsh" wrote:
> > Hello,
> > One day when i try to open my database om my local computer (Win 2000
> > server, SQL 2000 EE, sp3) i get message:
> > A connection could not be established to (LOCAL)
> > Reason: cannot open user default database. Login faied..
> > Please verify SQL Server is running and check your SQL Server
> > registration properties (by right-clicking on the (LOCAL) node) and try again.
> >
> > SQL Server is running and right-clicking produces just the same message.
> >
> > Can anybody say what happend and what to do.
> >
> > Thanks a lot.|||use ISQL
sample
ISQL -S<server> -U<user> -P<password>
if your default database not exist on server, isql will use master database
then, check your default database
select name,dbname from syslogins where name='<yourlogin>'
go
...
and if shall
exec sp_defaultdb 'login','database'
go
"olsh" wrote:
> Sorry, how can i check these if i have no access to SQL Server?
>
> "Aleksandar Grbic" wrote:
> > 1. check which database is default database for your login
> >
> > 2. default database exist on server?
> >
> > 3. check permissons on your default database
> >
> >
> > "olsh" wrote:
> >
> > > Hello,
> > > One day when i try to open my database om my local computer (Win 2000
> > > server, SQL 2000 EE, sp3) i get message:
> > > A connection could not be established to (LOCAL)
> > > Reason: cannot open user default database. Login faied..
> > > Please verify SQL Server is running and check your SQL Server
> > > registration properties (by right-clicking on the (LOCAL) node) and try again.
> > >
> > > SQL Server is running and right-clicking produces just the same message.
> > >
> > > Can anybody say what happend and what to do.
> > >
> > > Thanks a lot.|||Thanks, everything is OK now!!
"Aleksandar Grbic" wrote:
> use ISQL
> sample
> ISQL -S<server> -U<user> -P<password>
> if your default database not exist on server, isql will use master database
> then, check your default database
> select name,dbname from syslogins where name='<yourlogin>'
> go
> ...
> and if shall
> exec sp_defaultdb 'login','database'
> go
>
> "olsh" wrote:
> > Sorry, how can i check these if i have no access to SQL Server?
> >
> >
> > "Aleksandar Grbic" wrote:
> >
> > > 1. check which database is default database for your login
> > >
> > > 2. default database exist on server?
> > >
> > > 3. check permissons on your default database
> > >
> > >
> > > "olsh" wrote:
> > >
> > > > Hello,
> > > > One day when i try to open my database om my local computer (Win 2000
> > > > server, SQL 2000 EE, sp3) i get message:
> > > > A connection could not be established to (LOCAL)
> > > > Reason: cannot open user default database. Login faied..
> > > > Please verify SQL Server is running and check your SQL Server
> > > > registration properties (by right-clicking on the (LOCAL) node) and try again.
> > > >
> > > > SQL Server is running and right-clicking produces just the same message.
> > > >
> > > > Can anybody say what happend and what to do.
> > > >
> > > > Thanks a lot.