We install MSDE2000 under a named instance and with SQL Server
authentication, and specify a password for 'sa'.
I recently had someone install it on a system that already had SQL Server
installed.
On that system, we could not connect to the named instance using the "sa"
user and password specified in the installer. Using ODBC, we kept getting
the error 18452 - Login failed for user 'sa'.
How does the presence of SQL Server affect this? Does the 'sa' password for
the SQL Server default instance take precedence?
hi,
"JJ" <jjjj@.nospam.com> ha scritto nel messaggio
news:uAPJ05LGEHA.2732@.tk2msftngp13.phx.gbl...
> We install MSDE2000 under a named instance and with SQL Server
> authentication, and specify a password for 'sa'.
> I recently had someone install it on a system that already had SQL Server
> installed.
> On that system, we could not connect to the named instance using the "sa"
> user and password specified in the installer. Using ODBC, we kept getting
> the error 18452 - Login failed for user 'sa'.
> How does the presence of SQL Server affect this? Does the 'sa' password
for
> the SQL Server default instance take precedence?
>
it shoul'd really not...
all specified settings are instance specific, the only difference is that
the 1st instance (default) will listen to default TCP/IP port 1433, while
all other ubsequent instances will pass throught UDP port 1434 if they have
been set to dinamically retrieve the port number... but this another
story...
if you can reproduce the problem and are "sure" [ =;-) ] that the MSDE
instance has been installed specifying the SECURITYMODE=SQL parameter, you
are wellcome to open a case with Microsoft PSS...
thank you
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||hi again,
anyway, try checking the HKLM\Software\Microsoft\Microsoft SQL
Server\Instance Name\MSSQLServer\LoginMode registry key... it shoul'd be 2
or 0 for mixed mode authentication...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||That's the strange part - I did check that in the registry and it was set to
2, so I tried setting it to 0 (then stopped and restarted the MSDE instance)
and got the same error.
Unfortunately, I can't check it again because we ended up just using SQL
Server and uninstalling MSDE for the user with the problem. (It was
actually a mistake for the user to have done the install with MSDE because
usually if they have SQL Server already, we want them to just use that. I
can't think of a good reason for an end user to have both SQL Server and
MSDE installed on the same system. But I was curious to find out whether or
not it should have worked.)
It may indeed have been the dynamic port issue - I did not check the client
configuration to see if it was trying to go to a specific port (i.e. 1433).
But I would have thought it just wouldn't have connected since the server
name contained the instance name.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:c4ju2l$2h7scp$1@.ID-207518.news.uni-berlin.de...
> hi again,
> anyway, try checking the HKLM\Software\Microsoft\Microsoft SQL
> Server\Instance Name\MSSQLServer\LoginMode registry key... it shoul'd be 2
> or 0 for mixed mode authentication...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
Showing posts with label password. Show all posts
Showing posts with label password. Show all posts
Wednesday, March 21, 2012
Wednesday, March 7, 2012
missing password
Hi there,
I have run up a WSUS server and used msde for the sql database and
sods law I thought I'd be clever and use a different password to
normal which at the time I thought I'd remember and I've completely
forgot it.
By any chance does anyone know of a way I can now retrieve this as I
would like to link up the server in enterprise manager.
Any help would be appreciated, even if its too say I've got no chance.
Many thanks.Login to MSDE using windows authentication and change the password.
Steps:-
1. Login into MSDE machine using a Admin account
2. go to command prompt
3. Type OSQL -SSQL_Servername -E (enter - This will got to a SQL prompt)
4. Execute SP_Password NULL,'New_sa_password','SA'
This will change the SA password to the password you provide in step 4.
Thanks
Hari
"CJC" wrote:
> Hi there,
> I have run up a WSUS server and used msde for the sql database and
> sods law I thought I'd be clever and use a different password to
> normal which at the time I thought I'd remember and I've completely
> forgot it.
> By any chance does anyone know of a way I can now retrieve this as I
> would like to link up the server in enterprise manager.
> Any help would be appreciated, even if its too say I've got no chance.
> Many thanks.
>|||Thanks for your reply, I have only had chance to look at it.
This command for changing the password, will it matter what username I
initially used when setting it up, as I probably didnt use SA? Or is
this command saying I am creating this password for this username, so
in theory could I put 'joe.bloggs' instead of 'sa'
Also I'm terrible for being over cautious, is this likely to screw
anything else up, as currently the server is running fine, its just I
cannot link WSUS into enterprise manager.
Thanks again.
On 2 Feb, 20:54, Hari Prasad <HariPra...@.discussions.microsoft.com>
wrote:[vbcol=seagreen]
> Login to MSDE using windows authentication and change the password.
> Steps:-
> 1. Login into MSDE machine using a Admin account
> 2. go to command prompt
> 3. Type OSQL -SSQL_Servername -E (enter - This will got to a SQL prompt)
> 4. Execute SP_Password NULL,'New_sa_password','SA'
> This will change the SA password to the password you provide in step 4.
> Thanks
> Hari
> "CJC" wrote:
>
>
>
>
I have run up a WSUS server and used msde for the sql database and
sods law I thought I'd be clever and use a different password to
normal which at the time I thought I'd remember and I've completely
forgot it.
By any chance does anyone know of a way I can now retrieve this as I
would like to link up the server in enterprise manager.
Any help would be appreciated, even if its too say I've got no chance.
Many thanks.Login to MSDE using windows authentication and change the password.
Steps:-
1. Login into MSDE machine using a Admin account
2. go to command prompt
3. Type OSQL -SSQL_Servername -E (enter - This will got to a SQL prompt)
4. Execute SP_Password NULL,'New_sa_password','SA'
This will change the SA password to the password you provide in step 4.
Thanks
Hari
"CJC" wrote:
> Hi there,
> I have run up a WSUS server and used msde for the sql database and
> sods law I thought I'd be clever and use a different password to
> normal which at the time I thought I'd remember and I've completely
> forgot it.
> By any chance does anyone know of a way I can now retrieve this as I
> would like to link up the server in enterprise manager.
> Any help would be appreciated, even if its too say I've got no chance.
> Many thanks.
>|||Thanks for your reply, I have only had chance to look at it.
This command for changing the password, will it matter what username I
initially used when setting it up, as I probably didnt use SA? Or is
this command saying I am creating this password for this username, so
in theory could I put 'joe.bloggs' instead of 'sa'
Also I'm terrible for being over cautious, is this likely to screw
anything else up, as currently the server is running fine, its just I
cannot link WSUS into enterprise manager.
Thanks again.
On 2 Feb, 20:54, Hari Prasad <HariPra...@.discussions.microsoft.com>
wrote:[vbcol=seagreen]
> Login to MSDE using windows authentication and change the password.
> Steps:-
> 1. Login into MSDE machine using a Admin account
> 2. go to command prompt
> 3. Type OSQL -SSQL_Servername -E (enter - This will got to a SQL prompt)
> 4. Execute SP_Password NULL,'New_sa_password','SA'
> This will change the SA password to the password you provide in step 4.
> Thanks
> Hari
> "CJC" wrote:
>
>
>
>
missing password
Hi there,
I have run up a WSUS server and used msde for the sql database and
sods law I thought I'd be clever and use a different password to
normal which at the time I thought I'd remember and I've completely
forgot it.
By any chance does anyone know of a way I can now retrieve this as I
would like to link up the server in enterprise manager.
Any help would be appreciated, even if its too say I've got no chance.
Many thanks.
Thanks for your reply, I have only had chance to look at it.
This command for changing the password, will it matter what username I
initially used when setting it up, as I probably didnt use SA? Or is
this command saying I am creating this password for this username, so
in theory could I put 'joe.bloggs' instead of 'sa'
Also I'm terrible for being over cautious, is this likely to screw
anything else up, as currently the server is running fine, its just I
cannot link WSUS into enterprise manager.
Thanks again.
On 2 Feb, 20:54, Hari Prasad <HariPra...@.discussions.microsoft.com>
wrote:[vbcol=seagreen]
> Login to MSDE using windows authentication and change the password.
> Steps:-
> 1. Login into MSDE machine using a Admin account
> 2. go to command prompt
> 3. Type OSQL -SSQL_Servername -E (enter - This will got to a SQL prompt)
> 4. Execute SP_Password NULL,'New_sa_password','SA'
> This will change the SA password to the password you provide in step 4.
> Thanks
> Hari
> "CJC" wrote:
>
>
I have run up a WSUS server and used msde for the sql database and
sods law I thought I'd be clever and use a different password to
normal which at the time I thought I'd remember and I've completely
forgot it.
By any chance does anyone know of a way I can now retrieve this as I
would like to link up the server in enterprise manager.
Any help would be appreciated, even if its too say I've got no chance.
Many thanks.
Thanks for your reply, I have only had chance to look at it.
This command for changing the password, will it matter what username I
initially used when setting it up, as I probably didnt use SA? Or is
this command saying I am creating this password for this username, so
in theory could I put 'joe.bloggs' instead of 'sa'
Also I'm terrible for being over cautious, is this likely to screw
anything else up, as currently the server is running fine, its just I
cannot link WSUS into enterprise manager.
Thanks again.
On 2 Feb, 20:54, Hari Prasad <HariPra...@.discussions.microsoft.com>
wrote:[vbcol=seagreen]
> Login to MSDE using windows authentication and change the password.
> Steps:-
> 1. Login into MSDE machine using a Admin account
> 2. go to command prompt
> 3. Type OSQL -SSQL_Servername -E (enter - This will got to a SQL prompt)
> 4. Execute SP_Password NULL,'New_sa_password','SA'
> This will change the SA password to the password you provide in step 4.
> Thanks
> Hari
> "CJC" wrote:
>
>
missing password
Hi there,
I have run up a WSUS server and used msde for the sql database and
sods law I thought I'd be clever and use a different password to
normal which at the time I thought I'd remember and I've completely
forgot it.
By any chance does anyone know of a way I can now retrieve this as I
would like to link up the server in enterprise manager.
Any help would be appreciated, even if its too say I've got no chance.
Many thanks.Login to MSDE using windows authentication and change the password.
Steps:-
1. Login into MSDE machine using a Admin account
2. go to command prompt
3. Type OSQL -SSQL_Servername -E (enter - This will got to a SQL prompt)
4. Execute SP_Password NULL,'New_sa_password','SA'
This will change the SA password to the password you provide in step 4.
Thanks
Hari
"CJC" wrote:
> Hi there,
> I have run up a WSUS server and used msde for the sql database and
> sods law I thought I'd be clever and use a different password to
> normal which at the time I thought I'd remember and I've completely
> forgot it.
> By any chance does anyone know of a way I can now retrieve this as I
> would like to link up the server in enterprise manager.
> Any help would be appreciated, even if its too say I've got no chance.
> Many thanks.
>|||Thanks for your reply, I have only had chance to look at it.
This command for changing the password, will it matter what username I
initially used when setting it up, as I probably didnt use SA? Or is
this command saying I am creating this password for this username, so
in theory could I put 'joe.bloggs' instead of 'sa'
Also I'm terrible for being over cautious, is this likely to screw
anything else up, as currently the server is running fine, its just I
cannot link WSUS into enterprise manager.
Thanks again.
On 2 Feb, 20:54, Hari Prasad <HariPra...@.discussions.microsoft.com>
wrote:
> Login to MSDE using windows authentication and change the password.
> Steps:-
> 1. Login into MSDE machine using a Admin account
> 2. go to command prompt
> 3. Type OSQL -SSQL_Servername -E (enter - This will got to a SQL prompt)
> 4. Execute SP_Password NULL,'New_sa_password','SA'
> This will change the SA password to the password you provide in step 4.
> Thanks
> Hari
> "CJC" wrote:
> > Hi there,
> > I have run up a WSUS server and used msde for the sql database and
> > sods law I thought I'd be clever and use a different password to
> > normal which at the time I thought I'd remember and I've completely
> > forgot it.
> > By any chance does anyone know of a way I can now retrieve this as I
> > would like to link up the server in enterprise manager.
> > Any help would be appreciated, even if its too say I've got no chance.
> > Many thanks.
I have run up a WSUS server and used msde for the sql database and
sods law I thought I'd be clever and use a different password to
normal which at the time I thought I'd remember and I've completely
forgot it.
By any chance does anyone know of a way I can now retrieve this as I
would like to link up the server in enterprise manager.
Any help would be appreciated, even if its too say I've got no chance.
Many thanks.Login to MSDE using windows authentication and change the password.
Steps:-
1. Login into MSDE machine using a Admin account
2. go to command prompt
3. Type OSQL -SSQL_Servername -E (enter - This will got to a SQL prompt)
4. Execute SP_Password NULL,'New_sa_password','SA'
This will change the SA password to the password you provide in step 4.
Thanks
Hari
"CJC" wrote:
> Hi there,
> I have run up a WSUS server and used msde for the sql database and
> sods law I thought I'd be clever and use a different password to
> normal which at the time I thought I'd remember and I've completely
> forgot it.
> By any chance does anyone know of a way I can now retrieve this as I
> would like to link up the server in enterprise manager.
> Any help would be appreciated, even if its too say I've got no chance.
> Many thanks.
>|||Thanks for your reply, I have only had chance to look at it.
This command for changing the password, will it matter what username I
initially used when setting it up, as I probably didnt use SA? Or is
this command saying I am creating this password for this username, so
in theory could I put 'joe.bloggs' instead of 'sa'
Also I'm terrible for being over cautious, is this likely to screw
anything else up, as currently the server is running fine, its just I
cannot link WSUS into enterprise manager.
Thanks again.
On 2 Feb, 20:54, Hari Prasad <HariPra...@.discussions.microsoft.com>
wrote:
> Login to MSDE using windows authentication and change the password.
> Steps:-
> 1. Login into MSDE machine using a Admin account
> 2. go to command prompt
> 3. Type OSQL -SSQL_Servername -E (enter - This will got to a SQL prompt)
> 4. Execute SP_Password NULL,'New_sa_password','SA'
> This will change the SA password to the password you provide in step 4.
> Thanks
> Hari
> "CJC" wrote:
> > Hi there,
> > I have run up a WSUS server and used msde for the sql database and
> > sods law I thought I'd be clever and use a different password to
> > normal which at the time I thought I'd remember and I've completely
> > forgot it.
> > By any chance does anyone know of a way I can now retrieve this as I
> > would like to link up the server in enterprise manager.
> > Any help would be appreciated, even if its too say I've got no chance.
> > Many thanks.
Subscribe to:
Posts (Atom)