I have win2003 machine which is named fenermarket.
I have an installed instance which is FENERMARKET\ALISVERISSAATI.
I installed sp1 and sp2 too.
When i try to install default instance as another instance the setup process
give the error.Im sure that my Sa password is true. I choose windows
authentication as aut type.
SQL service MSSQLSERVER started successfully waiting for SQL service to
accept client connections
Service MSSQLSERVER started at Mon Feb 04 19:18:21 2008
Loaded DLL:
C:\WINDOWS\system32\Odbc32.dll
Version:
3.526.3959.0
SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=28000, level=-1, state=-1, native_error=18456, msg=[Microsoft][SQL
Native Client][SQL Server]Login failed for user 'sa'.
Error Code: 0x80074818 (18456)
Windows Error Text: Source File Name: lib\odbc_connection.cpp
Compiler Timestamp: Fri Jul 29 01:13:53 2005
Function Name: OdbcConnection::connect@.connect
Source Line Number: 148
-- Context ---
Connecting to SQL Server
ExecuteSqlCommands
Originial error was 80074818 (18456)
ipt
SqlScriptHlpr
Error Code: 18456
Where do you need the "sa" Login and it's password if you use Windows
Authentication in SQL Server Setup?
In this error, the key thing is to see the "State number" in Login Failed
error message. Here is a nice blog about this error:
http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx
Ekrem nsoy
"in da club" <s> wrote in message
news:umNJdQ1ZIHA.1164@.TK2MSFTNGP02.phx.gbl...
>I have win2003 machine which is named fenermarket.
> I have an installed instance which is FENERMARKET\ALISVERISSAATI.
> I installed sp1 and sp2 too.
> When i try to install default instance as another instance the setup
> process give the error.Im sure that my Sa password is true. I choose
> windows authentication as aut type.
>
> SQL service MSSQLSERVER started successfully waiting for SQL service to
> accept client connections
> Service MSSQLSERVER started at Mon Feb 04 19:18:21 2008
> Loaded DLL:
> C:\WINDOWS\system32\Odbc32.dll
> Version:
> 3.526.3959.0
>
> SQL_ERROR (-1) in OdbcConnection::connect
> sqlstate=28000, level=-1, state=-1, native_error=18456,
> msg=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.
> Error Code: 0x80074818 (18456)
> Windows Error Text: Source File Name: lib\odbc_connection.cpp
> Compiler Timestamp: Fri Jul 29 01:13:53 2005
> Function Name: OdbcConnection::connect@.connect
> Source Line Number: 148
>
> -- Context ---
>
> Connecting to SQL Server
> ExecuteSqlCommands
> Originial error was 80074818 (18456)
> ipt
> SqlScriptHlpr
>
> Error Code: 18456
>
|||i have choosen mixed mode. I know the url but i couldnt find any info about
my stuation . my error state id is not listed here.
sql
Showing posts with label installation. Show all posts
Showing posts with label installation. Show all posts
Thursday, March 29, 2012
DEFAULT INSTANCE INSTALLATION PROBLEM ON SQL2005
I have win2003 machine which is named fenermarket.
I have an installed instance which is FENERMARKET\ALISVERISSAATI.
I installed sp1 and sp2 too.
When i try to install default instance as another instance the setup process
give the error.Im sure that my Sa password is true. I choose windows
authentication as aut type.
SQL service MSSQLSERVER started successfully waiting for SQL service to
accept client connections
Service MSSQLSERVER started at Mon Feb 04 19:18:21 2008
Loaded DLL:
C:\WINDOWS\system32\Odbc32.dll
Version:
3.526.3959.0
SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=28000, level=-1, state=-1, native_error=18456, msg=[Microsoft][SQL
Native Client][SQL Server]Login failed for user 'sa'.
Error Code: 0x80074818 (18456)
Windows Error Text: Source File Name: lib\odbc_connection.cpp
Compiler Timestamp: Fri Jul 29 01:13:53 2005
Function Name: OdbcConnection::connect@.connect
Source Line Number: 148
-- Context ---
Connecting to SQL Server
ExecuteSqlCommands
Originial error was 80074818 (18456)
ipt
SqlScriptHlpr
Error Code: 18456Where do you need the "sa" Login and it's password if you use Windows
Authentication in SQL Server Setup?
In this error, the key thing is to see the "State number" in Login Failed
error message. Here is a nice blog about this error:
http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx
--
Ekrem Önsoy
"in da club" <s> wrote in message
news:umNJdQ1ZIHA.1164@.TK2MSFTNGP02.phx.gbl...
>I have win2003 machine which is named fenermarket.
> I have an installed instance which is FENERMARKET\ALISVERISSAATI.
> I installed sp1 and sp2 too.
> When i try to install default instance as another instance the setup
> process give the error.Im sure that my Sa password is true. I choose
> windows authentication as aut type.
>
> SQL service MSSQLSERVER started successfully waiting for SQL service to
> accept client connections
> Service MSSQLSERVER started at Mon Feb 04 19:18:21 2008
> Loaded DLL:
> C:\WINDOWS\system32\Odbc32.dll
> Version:
> 3.526.3959.0
>
> SQL_ERROR (-1) in OdbcConnection::connect
> sqlstate=28000, level=-1, state=-1, native_error=18456,
> msg=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.
> Error Code: 0x80074818 (18456)
> Windows Error Text: Source File Name: lib\odbc_connection.cpp
> Compiler Timestamp: Fri Jul 29 01:13:53 2005
> Function Name: OdbcConnection::connect@.connect
> Source Line Number: 148
>
> -- Context ---
>
> Connecting to SQL Server
> ExecuteSqlCommands
> Originial error was 80074818 (18456)
> ipt
> SqlScriptHlpr
>
> Error Code: 18456
>|||i have choosen mixed mode. I know the url but i couldnt find any info about
my stuation . my error state id is not listed here.
I have an installed instance which is FENERMARKET\ALISVERISSAATI.
I installed sp1 and sp2 too.
When i try to install default instance as another instance the setup process
give the error.Im sure that my Sa password is true. I choose windows
authentication as aut type.
SQL service MSSQLSERVER started successfully waiting for SQL service to
accept client connections
Service MSSQLSERVER started at Mon Feb 04 19:18:21 2008
Loaded DLL:
C:\WINDOWS\system32\Odbc32.dll
Version:
3.526.3959.0
SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=28000, level=-1, state=-1, native_error=18456, msg=[Microsoft][SQL
Native Client][SQL Server]Login failed for user 'sa'.
Error Code: 0x80074818 (18456)
Windows Error Text: Source File Name: lib\odbc_connection.cpp
Compiler Timestamp: Fri Jul 29 01:13:53 2005
Function Name: OdbcConnection::connect@.connect
Source Line Number: 148
-- Context ---
Connecting to SQL Server
ExecuteSqlCommands
Originial error was 80074818 (18456)
ipt
SqlScriptHlpr
Error Code: 18456Where do you need the "sa" Login and it's password if you use Windows
Authentication in SQL Server Setup?
In this error, the key thing is to see the "State number" in Login Failed
error message. Here is a nice blog about this error:
http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx
--
Ekrem Önsoy
"in da club" <s> wrote in message
news:umNJdQ1ZIHA.1164@.TK2MSFTNGP02.phx.gbl...
>I have win2003 machine which is named fenermarket.
> I have an installed instance which is FENERMARKET\ALISVERISSAATI.
> I installed sp1 and sp2 too.
> When i try to install default instance as another instance the setup
> process give the error.Im sure that my Sa password is true. I choose
> windows authentication as aut type.
>
> SQL service MSSQLSERVER started successfully waiting for SQL service to
> accept client connections
> Service MSSQLSERVER started at Mon Feb 04 19:18:21 2008
> Loaded DLL:
> C:\WINDOWS\system32\Odbc32.dll
> Version:
> 3.526.3959.0
>
> SQL_ERROR (-1) in OdbcConnection::connect
> sqlstate=28000, level=-1, state=-1, native_error=18456,
> msg=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.
> Error Code: 0x80074818 (18456)
> Windows Error Text: Source File Name: lib\odbc_connection.cpp
> Compiler Timestamp: Fri Jul 29 01:13:53 2005
> Function Name: OdbcConnection::connect@.connect
> Source Line Number: 148
>
> -- Context ---
>
> Connecting to SQL Server
> ExecuteSqlCommands
> Originial error was 80074818 (18456)
> ipt
> SqlScriptHlpr
>
> Error Code: 18456
>|||i have choosen mixed mode. I know the url but i couldnt find any info about
my stuation . my error state id is not listed here.
Tuesday, March 27, 2012
Default Instance
Our installation of SQL server 2000 has been installed as
a named instance, and I am trying to install SMS2003. I
have read in the documentation that SMS2003 cannot be run
on a named instance, and must be run on the default
instance.
Is there any way of switching the named instance to the
default instance, or does anyone have any ideas on how I
can overcome this problem without reinstalling SQL server?
Hi,
As far as I know, You need to reinstall SQL server to move from named to
default instance.
Thanks
Hari
MCDBA
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19fd601c44e18$8ac5ffb0$a301280a@.phx.gbl...
> Our installation of SQL server 2000 has been installed as
> a named instance, and I am trying to install SMS2003. I
> have read in the documentation that SMS2003 cannot be run
> on a named instance, and must be run on the default
> instance.
> Is there any way of switching the named instance to the
> default instance, or does anyone have any ideas on how I
> can overcome this problem without reinstalling SQL server?
|||You will have to re-install SQL... But you can get your databases back by
backup/restore or sp_detach_db sp_attach_db
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19fd601c44e18$8ac5ffb0$a301280a@.phx.gbl...
> Our installation of SQL server 2000 has been installed as
> a named instance, and I am trying to install SMS2003. I
> have read in the documentation that SMS2003 cannot be run
> on a named instance, and must be run on the default
> instance.
> Is there any way of switching the named instance to the
> default instance, or does anyone have any ideas on how I
> can overcome this problem without reinstalling SQL server?
|||Will this restore the security, or will I have to restore
the Master DB as well?
>--Original Message--
>You will have to re-install SQL... But you can get your
databases back by
>backup/restore or sp_detach_db sp_attach_db
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>"chris" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:19fd601c44e18$8ac5ffb0$a301280a@.phx.gbl...
as[vbcol=seagreen]
I[vbcol=seagreen]
run[vbcol=seagreen]
I[vbcol=seagreen]
server?
>
>.
>
|||Hi,
To restore the SQl Server Logins you have to restore the Master database as
well. This will ensure that your security chain is brought back as same as
old.
Master database can be restored only if you start sql server in single user
mode.
How to start SQl server in single user mode:-
Execute the below command from command prompt
sqlservr.exe -c -m
Thanks
Hari
MCDBA
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19e7e01c44e25$6a834200$a601280a@.phx.gbl...[vbcol=seagreen]
> Will this restore the security, or will I have to restore
> the Master DB as well?
> databases back by
> (PASS) and it's
> message
> as
> I
> run
> I
> server?
a named instance, and I am trying to install SMS2003. I
have read in the documentation that SMS2003 cannot be run
on a named instance, and must be run on the default
instance.
Is there any way of switching the named instance to the
default instance, or does anyone have any ideas on how I
can overcome this problem without reinstalling SQL server?
Hi,
As far as I know, You need to reinstall SQL server to move from named to
default instance.
Thanks
Hari
MCDBA
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19fd601c44e18$8ac5ffb0$a301280a@.phx.gbl...
> Our installation of SQL server 2000 has been installed as
> a named instance, and I am trying to install SMS2003. I
> have read in the documentation that SMS2003 cannot be run
> on a named instance, and must be run on the default
> instance.
> Is there any way of switching the named instance to the
> default instance, or does anyone have any ideas on how I
> can overcome this problem without reinstalling SQL server?
|||You will have to re-install SQL... But you can get your databases back by
backup/restore or sp_detach_db sp_attach_db
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19fd601c44e18$8ac5ffb0$a301280a@.phx.gbl...
> Our installation of SQL server 2000 has been installed as
> a named instance, and I am trying to install SMS2003. I
> have read in the documentation that SMS2003 cannot be run
> on a named instance, and must be run on the default
> instance.
> Is there any way of switching the named instance to the
> default instance, or does anyone have any ideas on how I
> can overcome this problem without reinstalling SQL server?
|||Will this restore the security, or will I have to restore
the Master DB as well?
>--Original Message--
>You will have to re-install SQL... But you can get your
databases back by
>backup/restore or sp_detach_db sp_attach_db
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>"chris" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:19fd601c44e18$8ac5ffb0$a301280a@.phx.gbl...
as[vbcol=seagreen]
I[vbcol=seagreen]
run[vbcol=seagreen]
I[vbcol=seagreen]
server?
>
>.
>
|||Hi,
To restore the SQl Server Logins you have to restore the Master database as
well. This will ensure that your security chain is brought back as same as
old.
Master database can be restored only if you start sql server in single user
mode.
How to start SQl server in single user mode:-
Execute the below command from command prompt
sqlservr.exe -c -m
Thanks
Hari
MCDBA
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19e7e01c44e25$6a834200$a601280a@.phx.gbl...[vbcol=seagreen]
> Will this restore the security, or will I have to restore
> the Master DB as well?
> databases back by
> (PASS) and it's
> message
> as
> I
> run
> I
> server?
Default Instance
Our installation of SQL server 2000 has been installed as
a named instance, and I am trying to install SMS2003. I
have read in the documentation that SMS2003 cannot be run
on a named instance, and must be run on the default
instance.
Is there any way of switching the named instance to the
default instance, or does anyone have any ideas on how I
can overcome this problem without reinstalling SQL server?Hi,
As far as I know, You need to reinstall SQL server to move from named to
default instance.
--
Thanks
Hari
MCDBA
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19fd601c44e18$8ac5ffb0$a301280a@.phx.gbl...
> Our installation of SQL server 2000 has been installed as
> a named instance, and I am trying to install SMS2003. I
> have read in the documentation that SMS2003 cannot be run
> on a named instance, and must be run on the default
> instance.
> Is there any way of switching the named instance to the
> default instance, or does anyone have any ideas on how I
> can overcome this problem without reinstalling SQL server?|||You will have to re-install SQL... But you can get your databases back by
backup/restore or sp_detach_db sp_attach_db
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19fd601c44e18$8ac5ffb0$a301280a@.phx.gbl...
> Our installation of SQL server 2000 has been installed as
> a named instance, and I am trying to install SMS2003. I
> have read in the documentation that SMS2003 cannot be run
> on a named instance, and must be run on the default
> instance.
> Is there any way of switching the named instance to the
> default instance, or does anyone have any ideas on how I
> can overcome this problem without reinstalling SQL server?|||Will this restore the security, or will I have to restore
the Master DB as well?
>--Original Message--
>You will have to re-install SQL... But you can get your
databases back by
>backup/restore or sp_detach_db sp_attach_db
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>"chris" <anonymous@.discussions.microsoft.com> wrote in
message
>news:19fd601c44e18$8ac5ffb0$a301280a@.phx.gbl...
>> Our installation of SQL server 2000 has been installed
as
>> a named instance, and I am trying to install SMS2003.
I
>> have read in the documentation that SMS2003 cannot be
run
>> on a named instance, and must be run on the default
>> instance.
>> Is there any way of switching the named instance to the
>> default instance, or does anyone have any ideas on how
I
>> can overcome this problem without reinstalling SQL
server?
>
>.
>|||Hi,
To restore the SQl Server Logins you have to restore the Master database as
well. This will ensure that your security chain is brought back as same as
old.
Master database can be restored only if you start sql server in single user
mode.
How to start SQl server in single user mode:-
Execute the below command from command prompt
sqlservr.exe -c -m
Thanks
Hari
MCDBA
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19e7e01c44e25$6a834200$a601280a@.phx.gbl...
> Will this restore the security, or will I have to restore
> the Master DB as well?
> >--Original Message--
> >You will have to re-install SQL... But you can get your
> databases back by
> >backup/restore or sp_detach_db sp_attach_db
> >
> >--
> >Wayne Snyder, MCDBA, SQL Server MVP
> >Mariner, Charlotte, NC
> >www.mariner-usa.com
> >(Please respond only to the newsgroups.)
> >
> >I support the Professional Association of SQL Server
> (PASS) and it's
> >community of SQL Server professionals.
> >www.sqlpass.org
> >
> >"chris" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:19fd601c44e18$8ac5ffb0$a301280a@.phx.gbl...
> >> Our installation of SQL server 2000 has been installed
> as
> >> a named instance, and I am trying to install SMS2003.
> I
> >> have read in the documentation that SMS2003 cannot be
> run
> >> on a named instance, and must be run on the default
> >> instance.
> >>
> >> Is there any way of switching the named instance to the
> >> default instance, or does anyone have any ideas on how
> I
> >> can overcome this problem without reinstalling SQL
> server?
> >
> >
> >.
> >
a named instance, and I am trying to install SMS2003. I
have read in the documentation that SMS2003 cannot be run
on a named instance, and must be run on the default
instance.
Is there any way of switching the named instance to the
default instance, or does anyone have any ideas on how I
can overcome this problem without reinstalling SQL server?Hi,
As far as I know, You need to reinstall SQL server to move from named to
default instance.
--
Thanks
Hari
MCDBA
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19fd601c44e18$8ac5ffb0$a301280a@.phx.gbl...
> Our installation of SQL server 2000 has been installed as
> a named instance, and I am trying to install SMS2003. I
> have read in the documentation that SMS2003 cannot be run
> on a named instance, and must be run on the default
> instance.
> Is there any way of switching the named instance to the
> default instance, or does anyone have any ideas on how I
> can overcome this problem without reinstalling SQL server?|||You will have to re-install SQL... But you can get your databases back by
backup/restore or sp_detach_db sp_attach_db
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19fd601c44e18$8ac5ffb0$a301280a@.phx.gbl...
> Our installation of SQL server 2000 has been installed as
> a named instance, and I am trying to install SMS2003. I
> have read in the documentation that SMS2003 cannot be run
> on a named instance, and must be run on the default
> instance.
> Is there any way of switching the named instance to the
> default instance, or does anyone have any ideas on how I
> can overcome this problem without reinstalling SQL server?|||Will this restore the security, or will I have to restore
the Master DB as well?
>--Original Message--
>You will have to re-install SQL... But you can get your
databases back by
>backup/restore or sp_detach_db sp_attach_db
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>"chris" <anonymous@.discussions.microsoft.com> wrote in
message
>news:19fd601c44e18$8ac5ffb0$a301280a@.phx.gbl...
>> Our installation of SQL server 2000 has been installed
as
>> a named instance, and I am trying to install SMS2003.
I
>> have read in the documentation that SMS2003 cannot be
run
>> on a named instance, and must be run on the default
>> instance.
>> Is there any way of switching the named instance to the
>> default instance, or does anyone have any ideas on how
I
>> can overcome this problem without reinstalling SQL
server?
>
>.
>|||Hi,
To restore the SQl Server Logins you have to restore the Master database as
well. This will ensure that your security chain is brought back as same as
old.
Master database can be restored only if you start sql server in single user
mode.
How to start SQl server in single user mode:-
Execute the below command from command prompt
sqlservr.exe -c -m
Thanks
Hari
MCDBA
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19e7e01c44e25$6a834200$a601280a@.phx.gbl...
> Will this restore the security, or will I have to restore
> the Master DB as well?
> >--Original Message--
> >You will have to re-install SQL... But you can get your
> databases back by
> >backup/restore or sp_detach_db sp_attach_db
> >
> >--
> >Wayne Snyder, MCDBA, SQL Server MVP
> >Mariner, Charlotte, NC
> >www.mariner-usa.com
> >(Please respond only to the newsgroups.)
> >
> >I support the Professional Association of SQL Server
> (PASS) and it's
> >community of SQL Server professionals.
> >www.sqlpass.org
> >
> >"chris" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:19fd601c44e18$8ac5ffb0$a301280a@.phx.gbl...
> >> Our installation of SQL server 2000 has been installed
> as
> >> a named instance, and I am trying to install SMS2003.
> I
> >> have read in the documentation that SMS2003 cannot be
> run
> >> on a named instance, and must be run on the default
> >> instance.
> >>
> >> Is there any way of switching the named instance to the
> >> default instance, or does anyone have any ideas on how
> I
> >> can overcome this problem without reinstalling SQL
> server?
> >
> >
> >.
> >
Default Instance
Our installation of SQL server 2000 has been installed as
a named instance, and I am trying to install SMS2003. I
have read in the documentation that SMS2003 cannot be run
on a named instance, and must be run on the default
instance.
Is there any way of switching the named instance to the
default instance, or does anyone have any ideas on how I
can overcome this problem without reinstalling SQL server?Hi,
As far as I know, You need to reinstall SQL server to move from named to
default instance.
Thanks
Hari
MCDBA
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19fd601c44e18$8ac5ffb0$a301280a@.phx
.gbl...
> Our installation of SQL server 2000 has been installed as
> a named instance, and I am trying to install SMS2003. I
> have read in the documentation that SMS2003 cannot be run
> on a named instance, and must be run on the default
> instance.
> Is there any way of switching the named instance to the
> default instance, or does anyone have any ideas on how I
> can overcome this problem without reinstalling SQL server?|||You will have to re-install SQL... But you can get your databases back by
backup/restore or sp_detach_db sp_attach_db
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19fd601c44e18$8ac5ffb0$a301280a@.phx
.gbl...
> Our installation of SQL server 2000 has been installed as
> a named instance, and I am trying to install SMS2003. I
> have read in the documentation that SMS2003 cannot be run
> on a named instance, and must be run on the default
> instance.
> Is there any way of switching the named instance to the
> default instance, or does anyone have any ideas on how I
> can overcome this problem without reinstalling SQL server?|||Will this restore the security, or will I have to restore
the Master DB as well?
>--Original Message--
>You will have to re-install SQL... But you can get your
databases back by
>backup/restore or sp_detach_db sp_attach_db
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>"chris" <anonymous@.discussions.microsoft.com> wrote in
message
> news:19fd601c44e18$8ac5ffb0$a301280a@.phx
.gbl...
as[vbcol=seagreen]
I[vbcol=seagreen]
run[vbcol=seagreen]
I[vbcol=seagreen]
server?[vbcol=seagreen]
>
>.
>|||Hi,
To restore the SQl Server Logins you have to restore the Master database as
well. This will ensure that your security chain is brought back as same as
old.
Master database can be restored only if you start sql server in single user
mode.
How to start SQl server in single user mode:-
Execute the below command from command prompt
sqlservr.exe -c -m
Thanks
Hari
MCDBA
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19e7e01c44e25$6a834200$a601280a@.phx
.gbl...[vbcol=seagreen]
> Will this restore the security, or will I have to restore
> the Master DB as well?
>
> databases back by
> (PASS) and it's
> message
> as
> I
> run
> I
> server?sql
a named instance, and I am trying to install SMS2003. I
have read in the documentation that SMS2003 cannot be run
on a named instance, and must be run on the default
instance.
Is there any way of switching the named instance to the
default instance, or does anyone have any ideas on how I
can overcome this problem without reinstalling SQL server?Hi,
As far as I know, You need to reinstall SQL server to move from named to
default instance.
Thanks
Hari
MCDBA
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19fd601c44e18$8ac5ffb0$a301280a@.phx
.gbl...
> Our installation of SQL server 2000 has been installed as
> a named instance, and I am trying to install SMS2003. I
> have read in the documentation that SMS2003 cannot be run
> on a named instance, and must be run on the default
> instance.
> Is there any way of switching the named instance to the
> default instance, or does anyone have any ideas on how I
> can overcome this problem without reinstalling SQL server?|||You will have to re-install SQL... But you can get your databases back by
backup/restore or sp_detach_db sp_attach_db
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19fd601c44e18$8ac5ffb0$a301280a@.phx
.gbl...
> Our installation of SQL server 2000 has been installed as
> a named instance, and I am trying to install SMS2003. I
> have read in the documentation that SMS2003 cannot be run
> on a named instance, and must be run on the default
> instance.
> Is there any way of switching the named instance to the
> default instance, or does anyone have any ideas on how I
> can overcome this problem without reinstalling SQL server?|||Will this restore the security, or will I have to restore
the Master DB as well?
>--Original Message--
>You will have to re-install SQL... But you can get your
databases back by
>backup/restore or sp_detach_db sp_attach_db
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>"chris" <anonymous@.discussions.microsoft.com> wrote in
message
> news:19fd601c44e18$8ac5ffb0$a301280a@.phx
.gbl...
as[vbcol=seagreen]
I[vbcol=seagreen]
run[vbcol=seagreen]
I[vbcol=seagreen]
server?[vbcol=seagreen]
>
>.
>|||Hi,
To restore the SQl Server Logins you have to restore the Master database as
well. This will ensure that your security chain is brought back as same as
old.
Master database can be restored only if you start sql server in single user
mode.
How to start SQl server in single user mode:-
Execute the below command from command prompt
sqlservr.exe -c -m
Thanks
Hari
MCDBA
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19e7e01c44e25$6a834200$a601280a@.phx
.gbl...[vbcol=seagreen]
> Will this restore the security, or will I have to restore
> the Master DB as well?
>
> databases back by
> (PASS) and it's
> message
> as
> I
> run
> I
> server?sql
Default installation to named one
Hi,
I have installed sql server on one of my box as a named installation and now
I want to change it to default one without re-installing sql server.
Please suggest how should I go for it. Also, whether it is possible or not.
Thanks in advance
Manu JaidkaHello,
You will have to install a default instance and copy the databases including
system databases over to default instance
using Backup and restore or detach and Attach.
Thanks
Hari
"manu" <manu@.discussions.microsoft.com> wrote in message
news:7A299083-671F-4457-B9CE-263AE17838C0@.microsoft.com...
> Hi,
> I have installed sql server on one of my box as a named installation and
> now
> I want to change it to default one without re-installing sql server.
> Please suggest how should I go for it. Also, whether it is possible or
> not.
> Thanks in advance
> Manu Jaidka
>
I have installed sql server on one of my box as a named installation and now
I want to change it to default one without re-installing sql server.
Please suggest how should I go for it. Also, whether it is possible or not.
Thanks in advance
Manu JaidkaHello,
You will have to install a default instance and copy the databases including
system databases over to default instance
using Backup and restore or detach and Attach.
Thanks
Hari
"manu" <manu@.discussions.microsoft.com> wrote in message
news:7A299083-671F-4457-B9CE-263AE17838C0@.microsoft.com...
> Hi,
> I have installed sql server on one of my box as a named installation and
> now
> I want to change it to default one without re-installing sql server.
> Please suggest how should I go for it. Also, whether it is possible or
> not.
> Thanks in advance
> Manu Jaidka
>
Default installation to named one
Hi,
I have installed sql server on one of my box as a named installation and now
I want to change it to default one without re-installing sql server.
Please suggest how should I go for it. Also, whether it is possible or not.
Thanks in advance
Manu Jaidka
Hello,
You will have to install a default instance and copy the databases including
system databases over to default instance
using Backup and restore or detach and Attach.
Thanks
Hari
"manu" <manu@.discussions.microsoft.com> wrote in message
news:7A299083-671F-4457-B9CE-263AE17838C0@.microsoft.com...
> Hi,
> I have installed sql server on one of my box as a named installation and
> now
> I want to change it to default one without re-installing sql server.
> Please suggest how should I go for it. Also, whether it is possible or
> not.
> Thanks in advance
> Manu Jaidka
>
I have installed sql server on one of my box as a named installation and now
I want to change it to default one without re-installing sql server.
Please suggest how should I go for it. Also, whether it is possible or not.
Thanks in advance
Manu Jaidka
Hello,
You will have to install a default instance and copy the databases including
system databases over to default instance
using Backup and restore or detach and Attach.
Thanks
Hari
"manu" <manu@.discussions.microsoft.com> wrote in message
news:7A299083-671F-4457-B9CE-263AE17838C0@.microsoft.com...
> Hi,
> I have installed sql server on one of my box as a named installation and
> now
> I want to change it to default one without re-installing sql server.
> Please suggest how should I go for it. Also, whether it is possible or
> not.
> Thanks in advance
> Manu Jaidka
>
Default installation to named one
Hi,
I have installed sql server on one of my box as a named installation and now
I want to change it to default one without re-installing sql server.
Please suggest how should I go for it. Also, whether it is possible or not.
Thanks in advance
Manu JaidkaHello,
You will have to install a default instance and copy the databases including
system databases over to default instance
using Backup and restore or detach and Attach.
Thanks
Hari
"manu" <manu@.discussions.microsoft.com> wrote in message
news:7A299083-671F-4457-B9CE-263AE17838C0@.microsoft.com...
> Hi,
> I have installed sql server on one of my box as a named installation and
> now
> I want to change it to default one without re-installing sql server.
> Please suggest how should I go for it. Also, whether it is possible or
> not.
> Thanks in advance
> Manu Jaidka
>
I have installed sql server on one of my box as a named installation and now
I want to change it to default one without re-installing sql server.
Please suggest how should I go for it. Also, whether it is possible or not.
Thanks in advance
Manu JaidkaHello,
You will have to install a default instance and copy the databases including
system databases over to default instance
using Backup and restore or detach and Attach.
Thanks
Hari
"manu" <manu@.discussions.microsoft.com> wrote in message
news:7A299083-671F-4457-B9CE-263AE17838C0@.microsoft.com...
> Hi,
> I have installed sql server on one of my box as a named installation and
> now
> I want to change it to default one without re-installing sql server.
> Please suggest how should I go for it. Also, whether it is possible or
> not.
> Thanks in advance
> Manu Jaidka
>
Default installation
I have built an application that uses SQLExpress. When I build the setup with a new setup Project I include in the prerequisites SQLExpress so that if the target PC has no SQL server installed the setup sequence will automatically install an instance.
The Serup Sequence installes SQL Server with default Instance name and settings. I need to make the setup package to install the SQL instance with a specific name and some other setting. These settings would be
/qb ADDLOCAL=ALL SECURITYMODE=SQL SAPWD=pass INSTANCENAME=instname DISABLENETWORKPROTOCOLS=0
if i run it from Command Line.
I searched a lot on my own and didnt find any way of predefining these setting. Tnx in advance
The instance name is hard coded into the manifests used to generate the SQL Express prerequisite and there is no way to dynamically change it. You would need to go in and alter the command line used to install SQL Express that is encoded in the manifest.
You can find more about how the prerequisties in VS work by searching MSDN for "generic bootstrapper". I've also posted instruction on how to build your own prerequisite for SQL Express SP2 (VS only has RTM) that may be instructive. My sample also installs to the default named instance, but again, you can make any changes you want. Check out this blog post for more information.
Finally, you can choose to write your own install wrapper and take full control over the installation process. There is a white paper that discusses how to embed SQL Express installation in a custom wrapper here.
Mike
Default installation
I have built an application that uses SQLExpress. When I build the setup with a new setup Project I include in the prerequisites SQLExpress so that if the target PC has no SQL server installed the setup sequence will automatically install an instance.
The Serup Sequence installes SQL Server with default Instance name and settings. I need to make the setup package to install the SQL instance with a specific name and some other setting. These settings would be
/qb ADDLOCAL=ALL SECURITYMODE=SQL SAPWD=pass INSTANCENAME=instname DISABLENETWORKPROTOCOLS=0
if i run it from Command Line.
I searched a lot on my own and didnt find any way of predefining these setting. Tnx in advance
The instance name is hard coded into the manifests used to generate the SQL Express prerequisite and there is no way to dynamically change it. You would need to go in and alter the command line used to install SQL Express that is encoded in the manifest.
You can find more about how the prerequisties in VS work by searching MSDN for "generic bootstrapper". I've also posted instruction on how to build your own prerequisite for SQL Express SP2 (VS only has RTM) that may be instructive. My sample also installs to the default named instance, but again, you can make any changes you want. Check out this blog post for more information.
Finally, you can choose to write your own install wrapper and take full control over the installation process. There is a white paper that discusses how to embed SQL Express installation in a custom wrapper here.
Mike
sql
Subscribe to:
Posts (Atom)