|
|
You're in the
sql server connect
group:SQL Server named instance problem with Windows Server 2003
sql server connect:
I have installed SQL Server 2000 on a Windows Server 2003 machine with an instance name of "TestDB". But I cannot connect to this instance from another machines. It doen't even show up in the Enterprise Manager's "Register SQL Server" window. But if I use the default instance, it works. Windows 2000 servers do not have this problem either. Thanks in advance, Soheil
Hi
Pls take a look at sp_addlinkedserver stored procedure in the BOL. You are going to create a linked server to the instance [quoted text, click to view] "Soheil" <soheil@soheil.com> wrote in message news:%23nxfuIOIGHA.1032@TK2MSFTNGP11.phx.gbl... > Hi, > > I have installed SQL Server 2000 on a Windows Server 2003 machine with an > instance name of "TestDB". > But I cannot connect to this instance from another machines. It doen't > even show up in the Enterprise Manager's > "Register SQL Server" window. > > But if I use the default instance, it works. Windows 2000 servers do not > have this problem either. > > Thanks in advance, > Soheil >
I do not want to link servers, I just want to connect to this server from a
windows application. Regards, Soheil [quoted text, click to view] "Uri Dimant" <urid@iscar.co.il> wrote in message news:OI7wdMOIGHA.648@TK2MSFTNGP14.phx.gbl... > Hi > Pls take a look at sp_addlinkedserver stored procedure in the BOL. You are > going to create a linked server to the instance > > > > > "Soheil" <soheil@soheil.com> wrote in message > news:%23nxfuIOIGHA.1032@TK2MSFTNGP11.phx.gbl... >> Hi, >> >> I have installed SQL Server 2000 on a Windows Server 2003 machine with an >> instance name of "TestDB". >> But I cannot connect to this instance from another machines. It doen't >> even show up in the Enterprise Manager's >> "Register SQL Server" window. >> >> But if I use the default instance, it works. Windows 2000 servers do not >> have this problem either. >> >> Thanks in advance, >> Soheil >> > >
Ok, then just type the full name and register , despite it is not showing up
in the window's list [quoted text, click to view] "Soheil" <soheil@soheil.com> wrote in message news:uNFcsPOIGHA.2704@TK2MSFTNGP15.phx.gbl... >I do not want to link servers, I just want to connect to this server from a >windows application. > > Regards, > Soheil > > "Uri Dimant" <urid@iscar.co.il> wrote in message > news:OI7wdMOIGHA.648@TK2MSFTNGP14.phx.gbl... >> Hi >> Pls take a look at sp_addlinkedserver stored procedure in the BOL. You >> are going to create a linked server to the instance >> >> >> >> >> "Soheil" <soheil@soheil.com> wrote in message >> news:%23nxfuIOIGHA.1032@TK2MSFTNGP11.phx.gbl... >>> Hi, >>> >>> I have installed SQL Server 2000 on a Windows Server 2003 machine with >>> an instance name of "TestDB". >>> But I cannot connect to this instance from another machines. It doen't >>> even show up in the Enterprise Manager's >>> "Register SQL Server" window. >>> >>> But if I use the default instance, it works. Windows 2000 servers do not >>> have this problem either. >>> >>> Thanks in advance, >>> Soheil >>> >> >> > >
Doesn't work. I get the "SQL Server doesn't exist or access denied".
[quoted text, click to view] "Uri Dimant" <urid@iscar.co.il> wrote in message news:e$gYYUOIGHA.2064@TK2MSFTNGP09.phx.gbl... > Ok, then just type the full name and register , despite it is not showing > up in the window's list > > > > > "Soheil" <soheil@soheil.com> wrote in message > news:uNFcsPOIGHA.2704@TK2MSFTNGP15.phx.gbl... >>I do not want to link servers, I just want to connect to this server from >>a windows application. >> >> Regards, >> Soheil >> >> "Uri Dimant" <urid@iscar.co.il> wrote in message >> news:OI7wdMOIGHA.648@TK2MSFTNGP14.phx.gbl... >>> Hi >>> Pls take a look at sp_addlinkedserver stored procedure in the BOL. You >>> are going to create a linked server to the instance >>> >>> >>> >>> >>> "Soheil" <soheil@soheil.com> wrote in message >>> news:%23nxfuIOIGHA.1032@TK2MSFTNGP11.phx.gbl... >>>> Hi, >>>> >>>> I have installed SQL Server 2000 on a Windows Server 2003 machine with >>>> an instance name of "TestDB". >>>> But I cannot connect to this instance from another machines. It doen't >>>> even show up in the Enterprise Manager's >>>> "Register SQL Server" window. >>>> >>>> But if I use the default instance, it works. Windows 2000 servers do >>>> not have this problem either. >>>> >>>> Thanks in advance, >>>> Soheil >>>> >>> >>> >> >> > >
How do you connect to the instance ? With Windows Authentication or Mixed
one? Did you get the same error when you connect via Windows Authentication? [quoted text, click to view] "Soheil" <soheil@soheil.com> wrote in message news:uQEJLWOIGHA.1676@TK2MSFTNGP09.phx.gbl... > Doesn't work. I get the "SQL Server doesn't exist or access denied". > > "Uri Dimant" <urid@iscar.co.il> wrote in message > news:e$gYYUOIGHA.2064@TK2MSFTNGP09.phx.gbl... >> Ok, then just type the full name and register , despite it is not showing >> up in the window's list >> >> >> >> >> "Soheil" <soheil@soheil.com> wrote in message >> news:uNFcsPOIGHA.2704@TK2MSFTNGP15.phx.gbl... >>>I do not want to link servers, I just want to connect to this server from >>>a windows application. >>> >>> Regards, >>> Soheil >>> >>> "Uri Dimant" <urid@iscar.co.il> wrote in message >>> news:OI7wdMOIGHA.648@TK2MSFTNGP14.phx.gbl... >>>> Hi >>>> Pls take a look at sp_addlinkedserver stored procedure in the BOL. You >>>> are going to create a linked server to the instance >>>> >>>> >>>> >>>> >>>> "Soheil" <soheil@soheil.com> wrote in message >>>> news:%23nxfuIOIGHA.1032@TK2MSFTNGP11.phx.gbl... >>>>> Hi, >>>>> >>>>> I have installed SQL Server 2000 on a Windows Server 2003 machine with >>>>> an instance name of "TestDB". >>>>> But I cannot connect to this instance from another machines. It doen't >>>>> even show up in the Enterprise Manager's >>>>> "Register SQL Server" window. >>>>> >>>>> But if I use the default instance, it works. Windows 2000 servers do >>>>> not have this problem either. >>>>> >>>>> Thanks in advance, >>>>> Soheil >>>>> >>>> >>>> >>> >>> >> >> > >
I use Mixed mode.
Using Windows Authentication alone doesnt work neither. [quoted text, click to view] "Uri Dimant" <urid@iscar.co.il> wrote in message news:uDxIjZOIGHA.1188@TK2MSFTNGP14.phx.gbl... > How do you connect to the instance ? With Windows Authentication or Mixed > one? > > Did you get the same error when you connect via Windows Authentication? > > > "Soheil" <soheil@soheil.com> wrote in message > news:uQEJLWOIGHA.1676@TK2MSFTNGP09.phx.gbl... >> Doesn't work. I get the "SQL Server doesn't exist or access denied". >> >> "Uri Dimant" <urid@iscar.co.il> wrote in message >> news:e$gYYUOIGHA.2064@TK2MSFTNGP09.phx.gbl... >>> Ok, then just type the full name and register , despite it is not >>> showing up in the window's list >>> >>> >>> >>> >>> "Soheil" <soheil@soheil.com> wrote in message >>> news:uNFcsPOIGHA.2704@TK2MSFTNGP15.phx.gbl... >>>>I do not want to link servers, I just want to connect to this server >>>>from a windows application. >>>> >>>> Regards, >>>> Soheil >>>> >>>> "Uri Dimant" <urid@iscar.co.il> wrote in message >>>> news:OI7wdMOIGHA.648@TK2MSFTNGP14.phx.gbl... >>>>> Hi >>>>> Pls take a look at sp_addlinkedserver stored procedure in the BOL. You >>>>> are going to create a linked server to the instance >>>>> >>>>> >>>>> >>>>> >>>>> "Soheil" <soheil@soheil.com> wrote in message >>>>> news:%23nxfuIOIGHA.1032@TK2MSFTNGP11.phx.gbl... >>>>>> Hi, >>>>>> >>>>>> I have installed SQL Server 2000 on a Windows Server 2003 machine >>>>>> with an instance name of "TestDB". >>>>>> But I cannot connect to this instance from another machines. It >>>>>> doen't even show up in the Enterprise Manager's >>>>>> "Register SQL Server" window. >>>>>> >>>>>> But if I use the default instance, it works. Windows 2000 servers do >>>>>> not have this problem either. >>>>>> >>>>>> Thanks in advance, >>>>>> Soheil >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
Did you start the instance?
sqlservr.exe -c -s {instancename} [quoted text, click to view] "Soheil" <soheil@soheil.com> wrote in message news:eh4ZPdOIGHA.528@TK2MSFTNGP12.phx.gbl... >I use Mixed mode. > Using Windows Authentication alone doesnt work neither. > > "Uri Dimant" <urid@iscar.co.il> wrote in message > news:uDxIjZOIGHA.1188@TK2MSFTNGP14.phx.gbl... >> How do you connect to the instance ? With Windows Authentication or Mixed >> one? >> >> Did you get the same error when you connect via Windows Authentication? >> >> >> "Soheil" <soheil@soheil.com> wrote in message >> news:uQEJLWOIGHA.1676@TK2MSFTNGP09.phx.gbl... >>> Doesn't work. I get the "SQL Server doesn't exist or access denied". >>> >>> "Uri Dimant" <urid@iscar.co.il> wrote in message >>> news:e$gYYUOIGHA.2064@TK2MSFTNGP09.phx.gbl... >>>> Ok, then just type the full name and register , despite it is not >>>> showing up in the window's list >>>> >>>> >>>> >>>> >>>> "Soheil" <soheil@soheil.com> wrote in message >>>> news:uNFcsPOIGHA.2704@TK2MSFTNGP15.phx.gbl... >>>>>I do not want to link servers, I just want to connect to this server >>>>>from a windows application. >>>>> >>>>> Regards, >>>>> Soheil >>>>> >>>>> "Uri Dimant" <urid@iscar.co.il> wrote in message >>>>> news:OI7wdMOIGHA.648@TK2MSFTNGP14.phx.gbl... >>>>>> Hi >>>>>> Pls take a look at sp_addlinkedserver stored procedure in the BOL. >>>>>> You >>>>>> are going to create a linked server to the instance >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> "Soheil" <soheil@soheil.com> wrote in message >>>>>> news:%23nxfuIOIGHA.1032@TK2MSFTNGP11.phx.gbl... >>>>>>> Hi, >>>>>>> >>>>>>> I have installed SQL Server 2000 on a Windows Server 2003 machine >>>>>>> with an instance name of "TestDB". >>>>>>> But I cannot connect to this instance from another machines. It >>>>>>> doen't even show up in the Enterprise Manager's >>>>>>> "Register SQL Server" window. >>>>>>> >>>>>>> But if I use the default instance, it works. Windows 2000 servers do >>>>>>> not have this problem either. >>>>>>> >>>>>>> Thanks in advance, >>>>>>> Soheil >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > begin 666 note.gif M1TE&.#EA# `+`(#_`(2&`,# P"'Y! $```$`+ `````,``L`0 (:C(\(H'S[ 68%R0&ED;M7,'[%S2YW#1)VJ;4P``.P`` ` end
Yes, its started.
[quoted text, click to view] "Uri Dimant" <urid@iscar.co.il> wrote in message news:%23evRGiOIGHA.3984@TK2MSFTNGP14.phx.gbl... > Did you start the instance? > sqlservr.exe -c -s {instancename} > > > > > > "Soheil" <soheil@soheil.com> wrote in message > news:eh4ZPdOIGHA.528@TK2MSFTNGP12.phx.gbl... >>I use Mixed mode. >> Using Windows Authentication alone doesnt work neither. >> >> "Uri Dimant" <urid@iscar.co.il> wrote in message >> news:uDxIjZOIGHA.1188@TK2MSFTNGP14.phx.gbl... >>> How do you connect to the instance ? With Windows Authentication or >>> Mixed >>> one? >>> >>> Did you get the same error when you connect via Windows Authentication? >>> >>> >>> "Soheil" <soheil@soheil.com> wrote in message >>> news:uQEJLWOIGHA.1676@TK2MSFTNGP09.phx.gbl... >>>> Doesn't work. I get the "SQL Server doesn't exist or access denied". >>>> >>>> "Uri Dimant" <urid@iscar.co.il> wrote in message >>>> news:e$gYYUOIGHA.2064@TK2MSFTNGP09.phx.gbl... >>>>> Ok, then just type the full name and register , despite it is not >>>>> showing up in the window's list >>>>> >>>>> >>>>> >>>>> >>>>> "Soheil" <soheil@soheil.com> wrote in message >>>>> news:uNFcsPOIGHA.2704@TK2MSFTNGP15.phx.gbl... >>>>>>I do not want to link servers, I just want to connect to this server >>>>>>from a windows application. >>>>>> >>>>>> Regards, >>>>>> Soheil >>>>>> >>>>>> "Uri Dimant" <urid@iscar.co.il> wrote in message >>>>>> news:OI7wdMOIGHA.648@TK2MSFTNGP14.phx.gbl... >>>>>>> Hi >>>>>>> Pls take a look at sp_addlinkedserver stored procedure in the BOL. >>>>>>> You >>>>>>> are going to create a linked server to the instance >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> "Soheil" <soheil@soheil.com> wrote in message >>>>>>> news:%23nxfuIOIGHA.1032@TK2MSFTNGP11.phx.gbl... >>>>>>>> Hi, >>>>>>>> >>>>>>>> I have installed SQL Server 2000 on a Windows Server 2003 machine >>>>>>>> with an instance name of "TestDB". >>>>>>>> But I cannot connect to this instance from another machines. It >>>>>>>> doen't even show up in the Enterprise Manager's >>>>>>>> "Register SQL Server" window. >>>>>>>> >>>>>>>> But if I use the default instance, it works. Windows 2000 servers >>>>>>>> do >>>>>>>> not have this problem either. >>>>>>>> >>>>>>>> Thanks in advance, >>>>>>>> Soheil >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > >
Hi
Do you really install the instance as it described in "How to install a named instance of SQL Server 2000 (Setup)"? If you do , I have no idea what is going on , sorry. I did just some testing on my machine and it worked fine. [quoted text, click to view] "Soheil" <soheil@soheil.com> wrote in message news:%23gHISrOIGHA.2912@tk2msftngp13.phx.gbl... > Yes, its started. > > "Uri Dimant" <urid@iscar.co.il> wrote in message > news:%23evRGiOIGHA.3984@TK2MSFTNGP14.phx.gbl... >> Did you start the instance? >> sqlservr.exe -c -s {instancename} >> >> >> >> >> >> "Soheil" <soheil@soheil.com> wrote in message >> news:eh4ZPdOIGHA.528@TK2MSFTNGP12.phx.gbl... >>>I use Mixed mode. >>> Using Windows Authentication alone doesnt work neither. >>> >>> "Uri Dimant" <urid@iscar.co.il> wrote in message >>> news:uDxIjZOIGHA.1188@TK2MSFTNGP14.phx.gbl... >>>> How do you connect to the instance ? With Windows Authentication or >>>> Mixed >>>> one? >>>> >>>> Did you get the same error when you connect via Windows Authentication? >>>> >>>> >>>> "Soheil" <soheil@soheil.com> wrote in message >>>> news:uQEJLWOIGHA.1676@TK2MSFTNGP09.phx.gbl... >>>>> Doesn't work. I get the "SQL Server doesn't exist or access denied". >>>>> >>>>> "Uri Dimant" <urid@iscar.co.il> wrote in message >>>>> news:e$gYYUOIGHA.2064@TK2MSFTNGP09.phx.gbl... >>>>>> Ok, then just type the full name and register , despite it is not >>>>>> showing up in the window's list >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> "Soheil" <soheil@soheil.com> wrote in message >>>>>> news:uNFcsPOIGHA.2704@TK2MSFTNGP15.phx.gbl... >>>>>>>I do not want to link servers, I just want to connect to this server >>>>>>>from a windows application. >>>>>>> >>>>>>> Regards, >>>>>>> Soheil >>>>>>> >>>>>>> "Uri Dimant" <urid@iscar.co.il> wrote in message >>>>>>> news:OI7wdMOIGHA.648@TK2MSFTNGP14.phx.gbl... >>>>>>>> Hi >>>>>>>> Pls take a look at sp_addlinkedserver stored procedure in the BOL. >>>>>>>> You >>>>>>>> are going to create a linked server to the instance >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> "Soheil" <soheil@soheil.com> wrote in message >>>>>>>> news:%23nxfuIOIGHA.1032@TK2MSFTNGP11.phx.gbl... >>>>>>>>> Hi, >>>>>>>>> >>>>>>>>> I have installed SQL Server 2000 on a Windows Server 2003 machine >>>>>>>>> with an instance name of "TestDB". >>>>>>>>> But I cannot connect to this instance from another machines. It >>>>>>>>> doen't even show up in the Enterprise Manager's >>>>>>>>> "Register SQL Server" window. >>>>>>>>> >>>>>>>>> But if I use the default instance, it works. Windows 2000 servers >>>>>>>>> do >>>>>>>>> not have this problem either. >>>>>>>>> >>>>>>>>> Thanks in advance, >>>>>>>>> Soheil >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> >> > >
hi,
[quoted text, click to view] Soheil wrote: > Hi, > > I have installed SQL Server 2000 on a Windows Server 2003 machine > with an instance name of "TestDB". > But I cannot connect to this instance from another machines. It > doen't even show up in the Enterprise Manager's > "Register SQL Server" window. > > But if I use the default instance, it works. Windows 2000 servers do > not have this problem either. can you please chek, using the Server Network Utility (svrnetcn.exe), the desired network protocols are enabled? -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
apoligise..
-- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply [quoted text, click to view] Steve Clark [MSFT] wrote: > Please don't cross-post like this. I see about 9 groups that are on > the list that have *nothing* to do with SQL or this problem. (such > as IPsec) > "Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message > news:43mue0F1ohuacU1@individual.net... >> hi, >> Soheil wrote: >>> Hi, >>> >>> I have installed SQL Server 2000 on a Windows Server 2003 machine >>> with an instance name of "TestDB". >>> But I cannot connect to this instance from another machines. It >>> doen't even show up in the Enterprise Manager's >>> "Register SQL Server" window. >>> >>> But if I use the default instance, it works. Windows 2000 servers do >>> not have this problem either. >> >> can you please chek, using the Server Network Utility >> (svrnetcn.exe), the desired network protocols are enabled? >> -- >> Andrea Montanari (Microsoft MVP - SQL Server) >> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org >> DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0 >> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a >> visual interface) >> --------- remove DMO to reply
Please don't cross-post like this. I see about 9 groups that are on the
list that have *nothing* to do with SQL or this problem. (such as IPsec) [quoted text, click to view] "Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message news:43mue0F1ohuacU1@individual.net... > hi, > Soheil wrote: >> Hi, >> >> I have installed SQL Server 2000 on a Windows Server 2003 machine >> with an instance name of "TestDB". >> But I cannot connect to this instance from another machines. It >> doen't even show up in the Enterprise Manager's >> "Register SQL Server" window. >> >> But if I use the default instance, it works. Windows 2000 servers do >> not have this problem either. > > can you please chek, using the Server Network Utility (svrnetcn.exe), the > desired network protocols are enabled? > -- > Andrea Montanari (Microsoft MVP - SQL Server) > http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org > DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0 > (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual > interface) > --------- remove DMO to reply >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |