|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server named instance problem with Windows Server 2003Hi,
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 Show quote "Soheil" <soh***@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 Show quote "Uri Dimant" <u***@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" <soh***@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 Show quote "Soheil" <soh***@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" <u***@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" <soh***@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".
Show quote "Uri Dimant" <u***@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" <soh***@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" <u***@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" <soh***@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? Show quote "Soheil" <soh***@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" <u***@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" <soh***@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" <u***@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" <soh***@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. Show quote "Uri Dimant" <u***@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" <soh***@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" <u***@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" <soh***@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" <u***@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" <soh***@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} Show quote "Soheil" <soh***@soheil.com> wrote in message [attached file: note.gif]news:eh4ZPdOIGHA.528@TK2MSFTNGP12.phx.gbl... >I use Mixed mode. > Using Windows Authentication alone doesnt work neither. > > "Uri Dimant" <u***@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" <soh***@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" <u***@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" <soh***@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" <u***@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" <soh***@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 think the nub of this when you say you can connect to a Windows 2000
box but not the 2003 box. Check your MDAC versions out as differing ones between the client and the server can cause issues with named instances. Also, one other think to check is the port allocated to the named instance - it might be different from the default. I f this is the case connect like so Servername\instancename:port_number Cheers Steve L Dominicus Data Systems Ltd Steve,
MDAC versions completely match and ports are ok too. Show quote "Steve L" <steve_lawren***@tiscali.co.uk> wrote in message news:1138109320.961017.158710@g14g2000cwa.googlegroups.com... > I think the nub of this when you say you can connect to a Windows 2000 > box but not the 2003 box. Check your MDAC versions out as differing > ones between the client and the server can cause issues with named > instances. > > Also, one other think to check is the port allocated to the named > instance - it might be different from the default. I f this is the case > connect like so > > Servername\instancename:port_number > > Cheers > > Steve L > Dominicus Data Systems Ltd > Yes, its started.
Show quote "Uri Dimant" <u***@iscar.co.il> wrote in message news:%23evRGiOIGHA.3984@TK2MSFTNGP14.phx.gbl... > Did you start the instance? > sqlservr.exe -c -s {instancename} > > > > > > "Soheil" <soh***@soheil.com> wrote in message > news:eh4ZPdOIGHA.528@TK2MSFTNGP12.phx.gbl... >>I use Mixed mode. >> Using Windows Authentication alone doesnt work neither. >> >> "Uri Dimant" <u***@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" <soh***@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" <u***@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" <soh***@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" <u***@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" <soh***@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. Show quote "Soheil" <soh***@soheil.com> wrote in message news:%23gHISrOIGHA.2912@tk2msftngp13.phx.gbl... > Yes, its started. > > "Uri Dimant" <u***@iscar.co.il> wrote in message > news:%23evRGiOIGHA.3984@TK2MSFTNGP14.phx.gbl... >> Did you start the instance? >> sqlservr.exe -c -s {instancename} >> >> >> >> >> >> "Soheil" <soh***@soheil.com> wrote in message >> news:eh4ZPdOIGHA.528@TK2MSFTNGP12.phx.gbl... >>>I use Mixed mode. >>> Using Windows Authentication alone doesnt work neither. >>> >>> "Uri Dimant" <u***@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" <soh***@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" <u***@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" <soh***@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" <u***@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" <soh***@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 >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> >> > > We too have the exact same issue
Our Windows 2003 server enterprise edition client machine can not connect to a namesd instance of SQL Server 2000 inatalled on a remote machine. But we can connect to it using Windows 2000 machines We have installed all latest windows updates and SQL Server 2000 SP4 on the client machine Show quote "Uri Dimant" wrote: > 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. > > > > > > "Soheil" <soh***@soheil.com> wrote in message > news:%23gHISrOIGHA.2912@tk2msftngp13.phx.gbl... > > Yes, its started. > > > > "Uri Dimant" <u***@iscar.co.il> wrote in message > > news:%23evRGiOIGHA.3984@TK2MSFTNGP14.phx.gbl... > >> Did you start the instance? > >> sqlservr.exe -c -s {instancename} > >> > >> > >> > >> > >> > >> "Soheil" <soh***@soheil.com> wrote in message > >> news:eh4ZPdOIGHA.528@TK2MSFTNGP12.phx.gbl... > >>>I use Mixed mode. > >>> Using Windows Authentication alone doesnt work neither. > >>> > >>> "Uri Dimant" <u***@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" <soh***@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" <u***@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" <soh***@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" <u***@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" <soh***@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 > >>>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>> > >>>>>>> > >>>>>> > >>>>>> > >>>>> > >>>>> > >>>> > >>>> > >>> > >>> > >> > >> > >> > > > > > > > Idea 1: Presuming you are using TCP/IP, using the Server Network Utility
determine the port number. Can you connect using the port number like <computer_name>,<port_number> such as ACCTG,1500 Idea 2: Do you have a SQL Server Browser Service and is it running? -- Show quoteRick Byham MCDBA, MCSE, MCSA Documentation Manager Microsoft, SQL Server Books Online This posting is provided "as is" with no warranties, and confers no rights. "Kiran" <Ki***@discussions.microsoft.com> wrote in message news:90023A5B-F25B-4E2F-BCCE-E68130F6EF71@microsoft.com... > We too have the exact same issue > > Our Windows 2003 server enterprise edition client machine can not connect > to > a namesd instance of SQL Server 2000 inatalled on a remote machine. > > But we can connect to it using Windows 2000 machines > > We have installed all latest windows updates and SQL Server 2000 SP4 on > the > client machine > > > "Uri Dimant" wrote: > >> 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. >> >> >> >> >> >> "Soheil" <soh***@soheil.com> wrote in message >> news:%23gHISrOIGHA.2912@tk2msftngp13.phx.gbl... >> > Yes, its started. >> > >> > "Uri Dimant" <u***@iscar.co.il> wrote in message >> > news:%23evRGiOIGHA.3984@TK2MSFTNGP14.phx.gbl... >> >> Did you start the instance? >> >> sqlservr.exe -c -s {instancename} >> >> >> >> >> >> >> >> >> >> >> >> "Soheil" <soh***@soheil.com> wrote in message >> >> news:eh4ZPdOIGHA.528@TK2MSFTNGP12.phx.gbl... >> >>>I use Mixed mode. >> >>> Using Windows Authentication alone doesnt work neither. >> >>> >> >>> "Uri Dimant" <u***@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" <soh***@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" <u***@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" <soh***@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" <u***@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" <soh***@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 >> >>>>>>>>> >> >>>>>>>> >> >>>>>>>> >> >>>>>>> >> >>>>>>> >> >>>>>> >> >>>>>> >> >>>>> >> >>>>> >> >>>> >> >>>> >> >>> >> >>> >> >> >> >> >> >> >> > >> > >> >> >> We are using Named pipes alone both at the server and the client
Show quote "Rick Byham [MS]" wrote: > Idea 1: Presuming you are using TCP/IP, using the Server Network Utility > determine the port number. Can you connect using the port number like > <computer_name>,<port_number> such as ACCTG,1500 > Idea 2: Do you have a SQL Server Browser Service and is it running? > -- > Rick Byham > MCDBA, MCSE, MCSA > Documentation Manager > Microsoft, SQL Server Books Online > This posting is provided "as is" with > no warranties, and confers no rights. > > "Kiran" <Ki***@discussions.microsoft.com> wrote in message > news:90023A5B-F25B-4E2F-BCCE-E68130F6EF71@microsoft.com... > > We too have the exact same issue > > > > Our Windows 2003 server enterprise edition client machine can not connect > > to > > a namesd instance of SQL Server 2000 inatalled on a remote machine. > > > > But we can connect to it using Windows 2000 machines > > > > We have installed all latest windows updates and SQL Server 2000 SP4 on > > the > > client machine > > > > > > "Uri Dimant" wrote: > > > >> 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. > >> > >> > >> > >> > >> > >> "Soheil" <soh***@soheil.com> wrote in message > >> news:%23gHISrOIGHA.2912@tk2msftngp13.phx.gbl... > >> > Yes, its started. > >> > > >> > "Uri Dimant" <u***@iscar.co.il> wrote in message > >> > news:%23evRGiOIGHA.3984@TK2MSFTNGP14.phx.gbl... > >> >> Did you start the instance? > >> >> sqlservr.exe -c -s {instancename} > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> "Soheil" <soh***@soheil.com> wrote in message > >> >> news:eh4ZPdOIGHA.528@TK2MSFTNGP12.phx.gbl... > >> >>>I use Mixed mode. > >> >>> Using Windows Authentication alone doesnt work neither. > >> >>> > >> >>> "Uri Dimant" <u***@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" <soh***@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" <u***@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" <soh***@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" <u***@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" <soh***@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 > >> >>>>>>>>> > >> >>>>>>>> > >> >>>>>>>> > >> >>>>>>> > >> >>>>>>> > >> >>>>>> > >> >>>>>> > >> >>>>> > >> >>>>> > >> >>>> > >> >>>> > >> >>> > >> >>> > >> >> > >> >> > >> >> > >> > > >> > > >> > >> > >> > > > Can you connect to the pipe name with
np:\\<servername>\pipe\MSSQL$<instancename>\SQL\query such as np:\\ACCTG\pipe\MSSQL$TesdDB\SQL\query -- Show quoteRick Byham MCDBA, MCSE, MCSA Documentation Manager, Microsoft, SQL Server Books Online This posting is provided "as is" with no warranties, and confers no rights. "Kiran" <Ki***@discussions.microsoft.com> wrote in message news:C4FF04BF-A1A0-4ABF-915C-9150793AA7B8@microsoft.com... > We are using Named pipes alone both at the server and the client > > "Rick Byham [MS]" wrote: > >> Idea 1: Presuming you are using TCP/IP, using the Server Network Utility >> determine the port number. Can you connect using the port number like >> <computer_name>,<port_number> such as ACCTG,1500 >> Idea 2: Do you have a SQL Server Browser Service and is it running? >> -- >> Rick Byham >> MCDBA, MCSE, MCSA >> Documentation Manager >> Microsoft, SQL Server Books Online >> This posting is provided "as is" with >> no warranties, and confers no rights. >> >> "Kiran" <Ki***@discussions.microsoft.com> wrote in message >> news:90023A5B-F25B-4E2F-BCCE-E68130F6EF71@microsoft.com... >> > We too have the exact same issue >> > >> > Our Windows 2003 server enterprise edition client machine can not >> > connect >> > to >> > a namesd instance of SQL Server 2000 inatalled on a remote machine. >> > >> > But we can connect to it using Windows 2000 machines >> > >> > We have installed all latest windows updates and SQL Server 2000 SP4 on >> > the >> > client machine >> > >> > >> > "Uri Dimant" wrote: >> > >> >> 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. >> >> >> >> >> >> >> >> >> >> >> >> "Soheil" <soh***@soheil.com> wrote in message >> >> news:%23gHISrOIGHA.2912@tk2msftngp13.phx.gbl... >> >> > Yes, its started. >> >> > >> >> > "Uri Dimant" <u***@iscar.co.il> wrote in message >> >> > news:%23evRGiOIGHA.3984@TK2MSFTNGP14.phx.gbl... >> >> >> Did you start the instance? >> >> >> sqlservr.exe -c -s {instancename} >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> "Soheil" <soh***@soheil.com> wrote in message >> >> >> news:eh4ZPdOIGHA.528@TK2MSFTNGP12.phx.gbl... >> >> >>>I use Mixed mode. >> >> >>> Using Windows Authentication alone doesnt work neither. >> >> >>> >> >> >>> "Uri Dimant" <u***@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" <soh***@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" <u***@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" <soh***@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" <u***@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" <soh***@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 Rick
Thanks for your tip, it worked with MS Sql Server 2000 Query Analyzer Is there any way we can create an alias so that clients can still refer to the named instance as <servername>\<Instance Name> Kiran Show quote "Rick Byham [MS]" wrote: > Can you connect to the pipe name with > np:\\<servername>\pipe\MSSQL$<instancename>\SQL\query > such as > np:\\ACCTG\pipe\MSSQL$TesdDB\SQL\query > -- > Rick Byham > MCDBA, MCSE, MCSA > Documentation Manager, > Microsoft, SQL Server Books Online > This posting is provided "as is" with > no warranties, and confers no rights. > > "Kiran" <Ki***@discussions.microsoft.com> wrote in message > news:C4FF04BF-A1A0-4ABF-915C-9150793AA7B8@microsoft.com... > > We are using Named pipes alone both at the server and the client > > > > "Rick Byham [MS]" wrote: > > > >> Idea 1: Presuming you are using TCP/IP, using the Server Network Utility > >> determine the port number. Can you connect using the port number like > >> <computer_name>,<port_number> such as ACCTG,1500 > >> Idea 2: Do you have a SQL Server Browser Service and is it running? > >> -- > >> Rick Byham > >> MCDBA, MCSE, MCSA > >> Documentation Manager > >> Microsoft, SQL Server Books Online > >> This posting is provided "as is" with > >> no warranties, and confers no rights. > >> > >> "Kiran" <Ki***@discussions.microsoft.com> wrote in message > >> news:90023A5B-F25B-4E2F-BCCE-E68130F6EF71@microsoft.com... > >> > We too have the exact same issue > >> > > >> > Our Windows 2003 server enterprise edition client machine can not > >> > connect > >> > to > >> > a namesd instance of SQL Server 2000 inatalled on a remote machine. > >> > > >> > But we can connect to it using Windows 2000 machines > >> > > >> > We have installed all latest windows updates and SQL Server 2000 SP4 on > >> > the > >> > client machine > >> > > >> > > >> > "Uri Dimant" wrote: > >> > > >> >> 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. > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> "Soheil" <soh***@soheil.com> wrote in message > >> >> news:%23gHISrOIGHA.2912@tk2msftngp13.phx.gbl... > >> >> > Yes, its started. > >> >> > > >> >> > "Uri Dimant" <u***@iscar.co.il> wrote in message > >> >> > news:%23evRGiOIGHA.3984@TK2MSFTNGP14.phx.gbl... > >> >> >> Did you start the instance? > >> >> >> sqlservr.exe -c -s {instancename} > >> >> >> > >> >> >> > >> >> >> > >> >> >> > >> >> >> > >> >> >> "Soheil" <soh***@soheil.com> wrote in message > >> >> >> news:eh4ZPdOIGHA.528@TK2MSFTNGP12.phx.gbl... > >> >> >>>I use Mixed mode. > >> >> >>> Using Windows Authentication alone doesnt work neither. > >> >> >>> > >> >> >>> "Uri Dimant" <u***@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" <soh***@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" <u***@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" <soh***@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" <u***@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" <soh***@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 > >> >> >>>>>>>>> > >> >> >>>>>>>> > >> >> >>>>>>>> > >> >> >>>>>>> > >> >> >>>>>>> > >> >> >>>>>> > >> >> >>>>>> > >> >> >>>>> > >> >> >>>>> > >> >> >>>> > >> >> >>>> > >> >> >>> > >> >> >>> > >> >> >> > >> >> >> > >> >> >> > >> >> > > >> >> > > >> >> > >> >> > >> >> > >> > >> > >> > > > Yes, you can use the Alias tab of the SQL Server Client Network Utility.
But you shouldn't have to. Two ideas: In the SQL Server Network Utility, on the General tab, in the Enabled Protocols box, select a protocol and then click Properties. Is the Hide server box selected? Or, did you ever install an edition of SQL Server 2005 on this computer? If you right-click My Computer and then click Manage, and then expand Services and Applications and then click Services, do you see the SQL Server Browser Service? If so, that will resolve the instance name to the port or pipe. -- Show quoteRick Byham MCDBA, MCSE, MCSA Documentation Manager, Microsoft, SQL Server Books Online This posting is provided "as is" with no warranties, and confers no rights. "Kiran" <Ki***@discussions.microsoft.com> wrote in message news:962F0E68-8477-42A9-ACB8-FE4D511A4F4F@microsoft.com... > Hi Rick > Thanks for your tip, it worked with MS Sql Server 2000 Query Analyzer > Is there any way we can create an alias so that clients can still refer > to the named instance as <servername>\<Instance Name> > > > Kiran > > "Rick Byham [MS]" wrote: > >> Can you connect to the pipe name with >> np:\\<servername>\pipe\MSSQL$<instancename>\SQL\query >> such as >> np:\\ACCTG\pipe\MSSQL$TesdDB\SQL\query >> -- >> Rick Byham >> MCDBA, MCSE, MCSA >> Documentation Manager, >> Microsoft, SQL Server Books Online >> This posting is provided "as is" with >> no warranties, and confers no rights. >> >> "Kiran" <Ki***@discussions.microsoft.com> wrote in message >> news:C4FF04BF-A1A0-4ABF-915C-9150793AA7B8@microsoft.com... >> > We are using Named pipes alone both at the server and the client >> > >> > "Rick Byham [MS]" wrote: >> > >> >> Idea 1: Presuming you are using TCP/IP, using the Server Network >> >> Utility >> >> determine the port number. Can you connect using the port number like >> >> <computer_name>,<port_number> such as ACCTG,1500 >> >> Idea 2: Do you have a SQL Server Browser Service and is it running? >> >> -- >> >> Rick Byham >> >> MCDBA, MCSE, MCSA >> >> Documentation Manager >> >> Microsoft, SQL Server Books Online >> >> This posting is provided "as is" with >> >> no warranties, and confers no rights. >> >> >> >> "Kiran" <Ki***@discussions.microsoft.com> wrote in message >> >> news:90023A5B-F25B-4E2F-BCCE-E68130F6EF71@microsoft.com... >> >> > We too have the exact same issue >> >> > >> >> > Our Windows 2003 server enterprise edition client machine can not >> >> > connect >> >> > to >> >> > a namesd instance of SQL Server 2000 inatalled on a remote machine. >> >> > >> >> > But we can connect to it using Windows 2000 machines >> >> > >> >> > We have installed all latest windows updates and SQL Server 2000 SP4 >> >> > on >> >> > the >> >> > client machine >> >> > >> >> > >> >> > "Uri Dimant" wrote: >> >> > >> >> >> 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. >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> "Soheil" <soh***@soheil.com> wrote in message >> >> >> news:%23gHISrOIGHA.2912@tk2msftngp13.phx.gbl... >> >> >> > Yes, its started. >> >> >> > >> >> >> > "Uri Dimant" <u***@iscar.co.il> wrote in message >> >> >> > news:%23evRGiOIGHA.3984@TK2MSFTNGP14.phx.gbl... >> >> >> >> Did you start the instance? >> >> >> >> sqlservr.exe -c -s {instancename} >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> "Soheil" <soh***@soheil.com> wrote in message >> >> >> >> news:eh4ZPdOIGHA.528@TK2MSFTNGP12.phx.gbl... >> >> >> >>>I use Mixed mode. >> >> >> >>> Using Windows Authentication alone doesnt work neither. >> >> >> >>> >> >> >> >>> "Uri Dimant" <u***@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" <soh***@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" <u***@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" <soh***@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" <u***@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" <soh***@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,
Soheil wrote: > Hi, can you please chek, using the Server Network Utility (svrnetcn.exe), the > > 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. 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) Show quote "Andrea Montanari" <andrea.sql***@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 > apoligise..
-- Show quoteAndrea 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 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.sql***@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 Soheil wrote:
> I have installed SQL Server 2000 on a Windows Server 2003 machine with an http://support.microsoft.com/kb/265808/en-us> 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. In addition, if Windows firewall is enabled on Windows Server 2003 SP1, you may need to create an exception for the port used by your SQL Server instance. The fact you didn't experience this issue ond Windows 2000 makes it seem highly likely this is part of your problem. Determine the port number your instance is using by following instructions in the above and manually create an exception for it. -- Chris Priede  |
|||||||||||||||||||||||
Other interesting topics