| Author |
SQL Server Default user database
|
|
| graz79 2005-08-06, 9:23 am |
| When our server was set up there were two accounts set up the sa and
the appliation accounts. these both had the same default database i.e.
SA was changed from master.
The default database has now been deleted.
is it possible to force our way onto the server?
Thanks
graz79
| |
| Tibor Karaszi 2005-08-06, 9:23 am |
| Login using isql.exe and use sp_defaultdb to change your default database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"graz79" <graz79@yahoo.co.uk> wrote in message
news:1123337769.180714.223470@o13g2000cwo.googlegroups.com...
> When our server was set up there were two accounts set up the sa and
> the appliation accounts. these both had the same default database i.e.
> SA was changed from master.
>
> The default database has now been deleted.
>
> is it possible to force our way onto the server?
>
> Thanks
>
> graz79
>
| |
| graz79 2005-08-06, 11:23 am |
| Thanks
that did it
| |
| Dan Guzman 2005-08-06, 1:23 pm |
| > Login using isql.exe and use sp_defaultdb to change your default database.
For command-line queries in SQL 7 and 2000, it's better to use OSQL.EXE
instead of ISQL.EXE. ISQL is provided only for backwards compatibility for
old-timers like you and me :-)
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
message news:ezGzuHpmFHA.3300@TK2MSFTNGP15.phx.gbl...
> Login using isql.exe and use sp_defaultdb to change your default database.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
> Blog: http:// solidqualitylearning
.com/blogs/tibor/
>
>
> "graz79" <graz79@yahoo.co.uk> wrote in message
> news:1123337769.180714.223470@o13g2000cwo.googlegroups.com...
>
| |
| Tibor Karaszi 2005-08-06, 1:23 pm |
| > For command-line queries in SQL 7 and 2000, it's better to use OSQL.EXE instead of ISQL.EXE. ISQL
> is provided only for backwards compatibility for old-timers like you and me :-)
Oh, I agree, in general. The reason I suggest ISQL in this particular case is that OSQL doesn't
allow you to login if the default database doesn't exist.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:%23jCzEUqmFHA.3316@TK2MSFTNGP14.phx.gbl...
>
> For command-line queries in SQL 7 and 2000, it's better to use OSQL.EXE instead of ISQL.EXE. ISQL
> is provided only for backwards compatibility for old-timers like you and me :-)
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in message
> news:ezGzuHpmFHA.3300@TK2MSFTNGP15.phx.gbl...
>
>
| |
| Dan Guzman 2005-08-07, 3:23 am |
| > Oh, I agree, in general. The reason I suggest ISQL in this particular case
> is that OSQL doesn't allow you to login if the default database doesn't
> exist.
I didn't know that ISQL allowed you to connect with an invalid default
database. When I find myself in such a situation, I specify the OSQL -d
command-line parameter to override the default database.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
message news:evGSFdqmFHA.1480@TK2MSFTNGP10.phx.gbl...
>
> Oh, I agree, in general. The reason I suggest ISQL in this particular case
> is that OSQL doesn't allow you to login if the default database doesn't
> exist.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
> Blog: http:// solidqualitylearning
.com/blogs/tibor/
>
>
> "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
> news:%23jCzEUqmFHA.3316@TK2MSFTNGP14.phx.gbl...
>
| |
| Tibor Karaszi 2005-08-07, 3:23 am |
| > I didn't know that ISQL allowed you to connect with an invalid default database.
You get a message that database doesn't exists (or something similar) and that isql fails back to
the master database.
> When I find myself in such a situation, I specify the OSQL -d command-line parameter to override
> the default database.
And I didn't know you could do that. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:e8mvSIwmFHA.2920@TK2MSFTNGP14.phx.gbl...
>
> I didn't know that ISQL allowed you to connect with an invalid default database. When I find
> myself in such a situation, I specify the OSQL -d command-line parameter to override the default
> database.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in message
> news:evGSFdqmFHA.1480@TK2MSFTNGP10.phx.gbl...
>
>
|
|
|
|