I installed SQL 2005 on a new machine last week. Created a database using
scripts. Worked fine for a few days.
Yesterday, I attached a database that had been created on another machine,
with SQL 2000. Seemed to work fine. I closed SQL Server to work on something
else, then opened it back up. It won't let me in now. It says that it
doesn't allow remote connections, even though I am doing it from the same
machine that it resides on.
Text of the message is below the line at the bottom of this.
I tried changing the way I log in, including Windows Authentication, SQL
Server authentication, using my network name, and then using the user name I
created just for this thing when I installed SQL Server. I alwasy get the
same message. I also tried connecting remotely from another machine.
I was able to use this same machine to connect to another SQL Server
instance on the network, so it's apparent that the installation of SQL
Server isn't messed up.
I know that I will probably get asked about an admin username and password,
but I don't know what mine is. I tried sa with no password, but it didn't
work.
This is really causing some problems and I have something due at noon today.
Any help appreciated.
If I uninstalled SQL Server and re-install, will that let me in then?
-----
TITLE: Connect to Server
--
Cannot connect to SERV423.
--
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server) (Microsoft SQL Server, Error: 2)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476
--
BUTTONS:
OK
--did you enable TCP/IP and gave a proper IP Address in network
configuration under configuration manager?|||I don't recall that being part of the installation. Is it something I can
change now?
"Shadow" <dinu_babu@.yahoo.com> wrote in message
news:1138289713.792093.149830@.z14g2000cwz.googlegroups.com...
> did you enable TCP/IP and gave a proper IP Address in network
> configuration under configuration manager?
>|||I had never seen Config mgr before you mentioned it. Opening it up showed me
that the services weren't running. I started them and it works now.
thanks
"Shadow" <dinu_babu@.yahoo.com> wrote in message
news:1138289713.792093.149830@.z14g2000cwz.googlegroups.com...
> did you enable TCP/IP and gave a proper IP Address in network
> configuration under configuration manager?
>
Showing posts with label machine. Show all posts
Showing posts with label machine. Show all posts
Tuesday, March 27, 2012
can't get in anymore
I installed SQL 2005 on a new machine last week. Created a database using
scripts. Worked fine for a few days.
Yesterday, I attached a database that had been created on another machine,
with SQL 2000. Seemed to work fine. I closed SQL Server to work on something
else, then opened it back up. It won't let me in now. It says that it
doesn't allow remote connections, even though I am doing it from the same
machine that it resides on.
Text of the message is below the line at the bottom of this.
I tried changing the way I log in, including Windows Authentication, SQL
Server authentication, using my network name, and then using the user name I
created just for this thing when I installed SQL Server. I alwasy get the
same message. I also tried connecting remotely from another machine.
I was able to use this same machine to connect to another SQL Server
instance on the network, so it's apparent that the installation of SQL
Server isn't messed up.
I know that I will probably get asked about an admin username and password,
but I don't know what mine is. I tried sa with no password, but it didn't
work.
This is really causing some problems and I have something due at noon today.
Any help appreciated.
If I uninstalled SQL Server and re-install, will that let me in then?
-----
TITLE: Connect to Server
Cannot connect to SERV423.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server) (Microsoft SQL Server, Error: 2)
For help, click:
http://go.microsoft.com/fwlink?ProdN...2&LinkId=20476
BUTTONS:
OK
did you enable TCP/IP and gave a proper IP Address in network
configuration under configuration manager?
|||I don't recall that being part of the installation. Is it something I can
change now?
"Shadow" <dinu_babu@.yahoo.com> wrote in message
news:1138289713.792093.149830@.z14g2000cwz.googlegr oups.com...
> did you enable TCP/IP and gave a proper IP Address in network
> configuration under configuration manager?
>
|||I had never seen Config mgr before you mentioned it. Opening it up showed me
that the services weren't running. I started them and it works now.
thanks
"Shadow" <dinu_babu@.yahoo.com> wrote in message
news:1138289713.792093.149830@.z14g2000cwz.googlegr oups.com...
> did you enable TCP/IP and gave a proper IP Address in network
> configuration under configuration manager?
>
scripts. Worked fine for a few days.
Yesterday, I attached a database that had been created on another machine,
with SQL 2000. Seemed to work fine. I closed SQL Server to work on something
else, then opened it back up. It won't let me in now. It says that it
doesn't allow remote connections, even though I am doing it from the same
machine that it resides on.
Text of the message is below the line at the bottom of this.
I tried changing the way I log in, including Windows Authentication, SQL
Server authentication, using my network name, and then using the user name I
created just for this thing when I installed SQL Server. I alwasy get the
same message. I also tried connecting remotely from another machine.
I was able to use this same machine to connect to another SQL Server
instance on the network, so it's apparent that the installation of SQL
Server isn't messed up.
I know that I will probably get asked about an admin username and password,
but I don't know what mine is. I tried sa with no password, but it didn't
work.
This is really causing some problems and I have something due at noon today.
Any help appreciated.
If I uninstalled SQL Server and re-install, will that let me in then?
-----
TITLE: Connect to Server
Cannot connect to SERV423.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server) (Microsoft SQL Server, Error: 2)
For help, click:
http://go.microsoft.com/fwlink?ProdN...2&LinkId=20476
BUTTONS:
OK
did you enable TCP/IP and gave a proper IP Address in network
configuration under configuration manager?
|||I don't recall that being part of the installation. Is it something I can
change now?
"Shadow" <dinu_babu@.yahoo.com> wrote in message
news:1138289713.792093.149830@.z14g2000cwz.googlegr oups.com...
> did you enable TCP/IP and gave a proper IP Address in network
> configuration under configuration manager?
>
|||I had never seen Config mgr before you mentioned it. Opening it up showed me
that the services weren't running. I started them and it works now.
thanks
"Shadow" <dinu_babu@.yahoo.com> wrote in message
news:1138289713.792093.149830@.z14g2000cwz.googlegr oups.com...
> did you enable TCP/IP and gave a proper IP Address in network
> configuration under configuration manager?
>
can't get in anymore
I installed SQL 2005 on a new machine last week. Created a database using
scripts. Worked fine for a few days.
Yesterday, I attached a database that had been created on another machine,
with SQL 2000. Seemed to work fine. I closed SQL Server to work on something
else, then opened it back up. It won't let me in now. It says that it
doesn't allow remote connections, even though I am doing it from the same
machine that it resides on.
Text of the message is below the line at the bottom of this.
I tried changing the way I log in, including Windows Authentication, SQL
Server authentication, using my network name, and then using the user name I
created just for this thing when I installed SQL Server. I alwasy get the
same message. I also tried connecting remotely from another machine.
I was able to use this same machine to connect to another SQL Server
instance on the network, so it's apparent that the installation of SQL
Server isn't messed up.
I know that I will probably get asked about an admin username and password,
but I don't know what mine is. I tried sa with no password, but it didn't
work.
This is really causing some problems and I have something due at noon today.
Any help appreciated.
If I uninstalled SQL Server and re-install, will that let me in then?
----
--
TITLE: Connect to Server
--
Cannot connect to SERV423.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server) (Microsoft SQL Server, Error: 2)
For help, click:
tID=2&LinkId=20476" target="_blank">http://go.microsoft.com/fwlink?Prod...=2&LinkId=20476
BUTTONS:
OK
--did you enable TCP/IP and gave a proper IP Address in network
configuration under configuration manager?|||I don't recall that being part of the installation. Is it something I can
change now?
"Shadow" <dinu_babu@.yahoo.com> wrote in message
news:1138289713.792093.149830@.z14g2000cwz.googlegroups.com...
> did you enable TCP/IP and gave a proper IP Address in network
> configuration under configuration manager?
>|||I had never seen Config mgr before you mentioned it. Opening it up showed me
that the services weren't running. I started them and it works now.
thanks
"Shadow" <dinu_babu@.yahoo.com> wrote in message
news:1138289713.792093.149830@.z14g2000cwz.googlegroups.com...
> did you enable TCP/IP and gave a proper IP Address in network
> configuration under configuration manager?
>sql
scripts. Worked fine for a few days.
Yesterday, I attached a database that had been created on another machine,
with SQL 2000. Seemed to work fine. I closed SQL Server to work on something
else, then opened it back up. It won't let me in now. It says that it
doesn't allow remote connections, even though I am doing it from the same
machine that it resides on.
Text of the message is below the line at the bottom of this.
I tried changing the way I log in, including Windows Authentication, SQL
Server authentication, using my network name, and then using the user name I
created just for this thing when I installed SQL Server. I alwasy get the
same message. I also tried connecting remotely from another machine.
I was able to use this same machine to connect to another SQL Server
instance on the network, so it's apparent that the installation of SQL
Server isn't messed up.
I know that I will probably get asked about an admin username and password,
but I don't know what mine is. I tried sa with no password, but it didn't
work.
This is really causing some problems and I have something due at noon today.
Any help appreciated.
If I uninstalled SQL Server and re-install, will that let me in then?
----
--
TITLE: Connect to Server
--
Cannot connect to SERV423.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server) (Microsoft SQL Server, Error: 2)
For help, click:
tID=2&LinkId=20476" target="_blank">http://go.microsoft.com/fwlink?Prod...=2&LinkId=20476
BUTTONS:
OK
--did you enable TCP/IP and gave a proper IP Address in network
configuration under configuration manager?|||I don't recall that being part of the installation. Is it something I can
change now?
"Shadow" <dinu_babu@.yahoo.com> wrote in message
news:1138289713.792093.149830@.z14g2000cwz.googlegroups.com...
> did you enable TCP/IP and gave a proper IP Address in network
> configuration under configuration manager?
>|||I had never seen Config mgr before you mentioned it. Opening it up showed me
that the services weren't running. I started them and it works now.
thanks
"Shadow" <dinu_babu@.yahoo.com> wrote in message
news:1138289713.792093.149830@.z14g2000cwz.googlegroups.com...
> did you enable TCP/IP and gave a proper IP Address in network
> configuration under configuration manager?
>sql
Sunday, March 25, 2012
Cant get Access Database Synchronizer set up on client machine
I have created a PPC application that uses ADS to synchronize my sqlce db with a desktop MS Access database. It works fine on my computers, but my client cant get it to work on his. Here is the situation.
His "Computer Name" as it's stated in his 'My Computer' properties is "PAVSGP024FE.NWFSC.NOAA.GOV"
However his Access.MDW File is located in the directory "C:\Documents and Settings\Joe Nobody\Application Data\Microsoft\Access\System.MDW".
There is no directory called "C:\Documents and Settings\PAVSGP024FE.NWFSC.NOAA.GOV\Application Data\Microsoft\Access\System.MDW".
His current config.xml file looks like this.
<?xml version="1.0" encoding="UTF-8"?>
<SystemNode>
<AccessDB>C:\Program Files\NOAA Release Logger\NOAA_ReleaseLogger.mdb</AccessDB>
<DeviceDB>\Program Files\NOAA Release Logger\NOAA_ReleaseLogger.sdf</DeviceDB>
<Login>Joe Nobody</Login>
<URL>http://Joe Nobody:1024/</URL>
<WinDir>C:\</WinDir>
</SystemNode>
He has tried adding port 1024 as an exception for his firewall settings, has installed Access Database Synchronizer on his computer, and I have also tried using the "long" computer name as the url setting in the config file. (i.e. <URL>http://PAVSGP024FE.NWFSC.NOAA.GOV:1024/</URL> but this throws the error
"The HTTP request failed due to incorrect format or content. Try restarting the IIS server.[]"
I dont know what else to try! Anybody have any suggestions?
I have had the same problems when I first installed. THen for some reason things started working. Now a few weeks later, when I get back to trying it, no work anymore. I suggest you read the readme.doc that comes with it. THere are some things to check there. Make sure IIS is running. THen you add a 1024 port if you have the firewall enabled. I also had some success when I manually copied the .cab file to the device, then installed that way. I don't think I have ever got it to work just downloading the sample project.
Another thing to verify is that your internet connection is going from device to desktop. Open IE and try to open http://<computer>:1024/. Presently, I am unable to do this so I think something is wrong on my Desktop platform. I am going to try another platform that used to work.
|||Tried to run the synchronizer on the other platform that it used to work on also. Now that one is not working either. I went through all the steps I know of to get it working, no luck. I cannot get the IE to link up to the web service either which I am thinking must be the main problem.
I am sorry to say, I need to give up trying to get it to work now.
|||Wanted to check, have you got it running now.
Please note: You do not IIS to run ADS applications. Stop the IIS and try.
The path of the .msw file should be C:\Documents and Settings\"User Name"\Application Data\Microsoft\Access\System.MDW.
So if his user name on the computer is "Joe Nobody" then specify the path as "C:\Documents and Settings\"User Name"\Application Data\Microsoft\Access\System.MDW" as indicated in your post.
|||We did finally get this working but, only because we gave up installing it on this particular computer. His computer was part of a business network and something about it would not allow this to work. Once he installed everything on a non-network computer everything worked as it should. So, unfortunately, we never did actually get to the root of this particular problem.
Mike
Cant get Access Database Synchronizer set up on client machine
I have created a PPC application that uses ADS to synchronize my sqlce db with a desktop MS Access database. It works fine on my computers, but my client cant get it to work on his. Here is the situation.
His "Computer Name" as it's stated in his 'My Computer' properties is "PAVSGP024FE.NWFSC.NOAA.GOV"
However his Access.MDW File is located in the directory "C:\Documents and Settings\Joe Nobody\Application Data\Microsoft\Access\System.MDW".
There is no directory called "C:\Documents and Settings\PAVSGP024FE.NWFSC.NOAA.GOV\Application Data\Microsoft\Access\System.MDW".
His current config.xml file looks like this.
<?xml version="1.0" encoding="UTF-8"?>
<SystemNode>
<AccessDB>C:\Program Files\NOAA Release Logger\NOAA_ReleaseLogger.mdb</AccessDB>
<DeviceDB>\Program Files\NOAA Release Logger\NOAA_ReleaseLogger.sdf</DeviceDB>
<Login>Joe Nobody</Login>
<URL>http://Joe Nobody:1024/</URL>
<WinDir>C:\</WinDir>
</SystemNode>
He has tried adding port 1024 as an exception for his firewall settings, has installed Access Database Synchronizer on his computer, and I have also tried using the "long" computer name as the url setting in the config file. (i.e. <URL>http://PAVSGP024FE.NWFSC.NOAA.GOV:1024/</URL> but this throws the error
"The HTTP request failed due to incorrect format or content. Try restarting the IIS server.[]"
I dont know what else to try! Anybody have any suggestions?
I have had the same problems when I first installed. THen for some reason things started working. Now a few weeks later, when I get back to trying it, no work anymore. I suggest you read the readme.doc that comes with it. THere are some things to check there. Make sure IIS is running. THen you add a 1024 port if you have the firewall enabled. I also had some success when I manually copied the .cab file to the device, then installed that way. I don't think I have ever got it to work just downloading the sample project.
Another thing to verify is that your internet connection is going from device to desktop. Open IE and try to open http://<computer>:1024/. Presently, I am unable to do this so I think something is wrong on my Desktop platform. I am going to try another platform that used to work.
|||Tried to run the synchronizer on the other platform that it used to work on also. Now that one is not working either. I went through all the steps I know of to get it working, no luck. I cannot get the IE to link up to the web service either which I am thinking must be the main problem.
I am sorry to say, I need to give up trying to get it to work now.
|||Wanted to check, have you got it running now.
Please note: You do not IIS to run ADS applications. Stop the IIS and try.
The path of the .msw file should be C:\Documents and Settings\"User Name"\Application Data\Microsoft\Access\System.MDW.
So if his user name on the computer is "Joe Nobody" then specify the path as "C:\Documents and Settings\"User Name"\Application Data\Microsoft\Access\System.MDW" as indicated in your post.
|||We did finally get this working but, only because we gave up installing it on this particular computer. His computer was part of a business network and something about it would not allow this to work. Once he installed everything on a non-network computer everything worked as it should. So, unfortunately, we never did actually get to the root of this particular problem.
Mike
CAN'T FULLY UNINSTALL SQL SERVER 2005 STANDARD
We have a Windows Server 2003 SP1 machine with two hard drives. I
installed MS SQL Server 2005 without paying attantion to where it
installed to. The c: drive is very small while d: is large. SQL
installed on c:. Apparentely, log files were growing and filled up all
the space on c:. I couldn't access SQL Server and decided uninstall it.
I went ahead and uninstall all components via add/remove programs.
After that I noticed all sql folders on c: are present, all services
are running and I was able to open Management Studio. At the same time
no SQL products are listed in add/remove. I need to fully uninstall it.
I tried command prompt pointing to the setup.exe file (where I copied
disks since it is a remote server) and failed.
Please, help!!!
StanYou did a reboot, right?
"suslikovich" <suslikovich@.yahoo.com> wrote in message
news:1146518232.810806.181140@.y43g2000cwc.googlegroups.com...
> We have a Windows Server 2003 SP1 machine with two hard drives. I
> installed MS SQL Server 2005 without paying attantion to where it
> installed to. The c: drive is very small while d: is large. SQL
> installed on c:. Apparentely, log files were growing and filled up all
> the space on c:. I couldn't access SQL Server and decided uninstall it.
> I went ahead and uninstall all components via add/remove programs.
> After that I noticed all sql folders on c: are present, all services
> are running and I was able to open Management Studio. At the same time
> no SQL products are listed in add/remove. I need to fully uninstall it.
> I tried command prompt pointing to the setup.exe file (where I copied
> disks since it is a remote server) and failed.
> Please, help!!!
> Stan
>|||Yes, I did a reboot after I uninstalled all sql products.
Stan
installed MS SQL Server 2005 without paying attantion to where it
installed to. The c: drive is very small while d: is large. SQL
installed on c:. Apparentely, log files were growing and filled up all
the space on c:. I couldn't access SQL Server and decided uninstall it.
I went ahead and uninstall all components via add/remove programs.
After that I noticed all sql folders on c: are present, all services
are running and I was able to open Management Studio. At the same time
no SQL products are listed in add/remove. I need to fully uninstall it.
I tried command prompt pointing to the setup.exe file (where I copied
disks since it is a remote server) and failed.
Please, help!!!
StanYou did a reboot, right?
"suslikovich" <suslikovich@.yahoo.com> wrote in message
news:1146518232.810806.181140@.y43g2000cwc.googlegroups.com...
> We have a Windows Server 2003 SP1 machine with two hard drives. I
> installed MS SQL Server 2005 without paying attantion to where it
> installed to. The c: drive is very small while d: is large. SQL
> installed on c:. Apparentely, log files were growing and filled up all
> the space on c:. I couldn't access SQL Server and decided uninstall it.
> I went ahead and uninstall all components via add/remove programs.
> After that I noticed all sql folders on c: are present, all services
> are running and I was able to open Management Studio. At the same time
> no SQL products are listed in add/remove. I need to fully uninstall it.
> I tried command prompt pointing to the setup.exe file (where I copied
> disks since it is a remote server) and failed.
> Please, help!!!
> Stan
>|||Yes, I did a reboot after I uninstalled all sql products.
Stan
Can't find server
Hello
I installed the old MSDE 2000 (not release a) on a Windows XP Pro machine. I
manage the DB with the MSDE Manager from Vale Software. On the machine it
self, it works fine. I can select the DB and connect as 'sa' with password.
But on every other machine in the network, I can't connect to the DB. I can
ping to the server, that's no problem. I can chose the server in MSDE
Manager (and other DB-Tools like 'Aqua Data Studio' and 'DBVisualizer') but
I always get an error message like 'Cannot find server'. On the XP machine
there is no firewall running and -of course- the SQL-Server task is started.
The port 1433 isn't blocked.
Have enyone an idea why I can connect the DB on the machine it self but not
from every other machine in the network?
Thanks a lot
Dani
It's possible that the server does not have the network connectivity library
enabled.
i don't know how re-enable it in MSDE after MSDE is already installed.
Although i know it can be done, i read it a few days ago in the MSDE2000A
readme.
If it were SQL server, i'd say use the "Server Network Utility" (i think
it's called that). In that you can enable/disable tcpip,netbios,
multiprotocol, flatulance, etc.
"Daniel Geisseler" <d.geisseler@.gmx.net> wrote in message
news:2lk43sFd4pjhU1@.uni-berlin.de...
> Hello
> I installed the old MSDE 2000 (not release a) on a Windows XP Pro machine.
I
> manage the DB with the MSDE Manager from Vale Software. On the machine it
> self, it works fine. I can select the DB and connect as 'sa' with
password.
> But on every other machine in the network, I can't connect to the DB. I
can
> ping to the server, that's no problem. I can chose the server in MSDE
> Manager (and other DB-Tools like 'Aqua Data Studio' and 'DBVisualizer')
but
> I always get an error message like 'Cannot find server'. On the XP machine
> there is no firewall running and -of course- the SQL-Server task is
started.
> The port 1433 isn't blocked.
> Have enyone an idea why I can connect the DB on the machine it self but
not
> from every other machine in the network?
> Thanks a lot
> Dani
>
|||If you run svrnetcn.exe from the /Program Files/Microsoft SQL
Server/80/Tools/BINN folder it will bring up the Server network utility, you
can make sure the network libraries are enabled.
HTH
Dylan Kruger
"Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
news:eGyjL5ZaEHA.1048@.tk2msftngp13.phx.gbl...
> It's possible that the server does not have the network connectivity
> library
> enabled.
> i don't know how re-enable it in MSDE after MSDE is already installed.
> Although i know it can be done, i read it a few days ago in the MSDE2000A
> readme.
> If it were SQL server, i'd say use the "Server Network Utility" (i think
> it's called that). In that you can enable/disable tcpip,netbios,
> multiprotocol, flatulance, etc.
>
> "Daniel Geisseler" <d.geisseler@.gmx.net> wrote in message
> news:2lk43sFd4pjhU1@.uni-berlin.de...
> I
> password.
> can
> but
> started.
> not
>
|||Yeah, exactly that's it! The TCP/IP was disabled. I don't now why but after
I startet again, it works fine.
1000 thanks to you...
Dani
1000 thanks
"Dylan kruger" <carmellobear1@.hotmail.com> schrieb im Newsbeitrag
news:eC7EjuaaEHA.3112@.tk2msftngp13.phx.gbl...
> If you run svrnetcn.exe from the /Program Files/Microsoft SQL
> Server/80/Tools/BINN folder it will bring up the Server network utility,
you[vbcol=seagreen]
> can make sure the network libraries are enabled.
> HTH
> Dylan Kruger
> "Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
> news:eGyjL5ZaEHA.1048@.tk2msftngp13.phx.gbl...
MSDE2000A[vbcol=seagreen]
it
>
|||It's a new feature of MSDE, that by default it doesn't act like any other
server application on earth.
Go figure.
Probably Microsoft's tired of hearing people XXXXX about being
wormed/hacked/infected, and they just say, "Fine, your XXX get's no
connectivity anymore. Suck it!"
"Daniel Geisseler" <d.geisseler@.gmx.net> wrote in message
news:2lmm2oFept7kU1@.uni-berlin.de...
> Yeah, exactly that's it! The TCP/IP was disabled. I don't now why but
after[vbcol=seagreen]
> I startet again, it works fine.
> 1000 thanks to you...
> Dani
>
> 1000 thanks
> "Dylan kruger" <carmellobear1@.hotmail.com> schrieb im Newsbeitrag
> news:eC7EjuaaEHA.3112@.tk2msftngp13.phx.gbl...
> you
> MSDE2000A
think[vbcol=seagreen]
machine[vbcol=seagreen]
> it
I[vbcol=seagreen]
'DBVisualizer')[vbcol=seagreen]
but
>
|||I had a similar problem - I was not able to connect to the MSDE from
any other machine. I had tried openning the TCP/IP Port (1433) and even
shutting down the Firewall.
Eventually, I was able to able to fix the issue by adding the registry
value for "ProtocolList" under HKEY_LOCAL_MACHINE -> SOFTWARE ->
Microsoft -> MSSQLServer -> SuperSocketNetLib
But now I have a different issue. How can I connect to the MSDE
instance with DBVisualizer? I tried to create a connection but when I
try to select / edit a Driver the drop down is empty and I cannot get
one from the list that I get by hitting the Edit button.
Please help.
- manzoor
I installed the old MSDE 2000 (not release a) on a Windows XP Pro machine. I
manage the DB with the MSDE Manager from Vale Software. On the machine it
self, it works fine. I can select the DB and connect as 'sa' with password.
But on every other machine in the network, I can't connect to the DB. I can
ping to the server, that's no problem. I can chose the server in MSDE
Manager (and other DB-Tools like 'Aqua Data Studio' and 'DBVisualizer') but
I always get an error message like 'Cannot find server'. On the XP machine
there is no firewall running and -of course- the SQL-Server task is started.
The port 1433 isn't blocked.
Have enyone an idea why I can connect the DB on the machine it self but not
from every other machine in the network?
Thanks a lot
Dani
It's possible that the server does not have the network connectivity library
enabled.
i don't know how re-enable it in MSDE after MSDE is already installed.
Although i know it can be done, i read it a few days ago in the MSDE2000A
readme.
If it were SQL server, i'd say use the "Server Network Utility" (i think
it's called that). In that you can enable/disable tcpip,netbios,
multiprotocol, flatulance, etc.
"Daniel Geisseler" <d.geisseler@.gmx.net> wrote in message
news:2lk43sFd4pjhU1@.uni-berlin.de...
> Hello
> I installed the old MSDE 2000 (not release a) on a Windows XP Pro machine.
I
> manage the DB with the MSDE Manager from Vale Software. On the machine it
> self, it works fine. I can select the DB and connect as 'sa' with
password.
> But on every other machine in the network, I can't connect to the DB. I
can
> ping to the server, that's no problem. I can chose the server in MSDE
> Manager (and other DB-Tools like 'Aqua Data Studio' and 'DBVisualizer')
but
> I always get an error message like 'Cannot find server'. On the XP machine
> there is no firewall running and -of course- the SQL-Server task is
started.
> The port 1433 isn't blocked.
> Have enyone an idea why I can connect the DB on the machine it self but
not
> from every other machine in the network?
> Thanks a lot
> Dani
>
|||If you run svrnetcn.exe from the /Program Files/Microsoft SQL
Server/80/Tools/BINN folder it will bring up the Server network utility, you
can make sure the network libraries are enabled.
HTH
Dylan Kruger
"Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
news:eGyjL5ZaEHA.1048@.tk2msftngp13.phx.gbl...
> It's possible that the server does not have the network connectivity
> library
> enabled.
> i don't know how re-enable it in MSDE after MSDE is already installed.
> Although i know it can be done, i read it a few days ago in the MSDE2000A
> readme.
> If it were SQL server, i'd say use the "Server Network Utility" (i think
> it's called that). In that you can enable/disable tcpip,netbios,
> multiprotocol, flatulance, etc.
>
> "Daniel Geisseler" <d.geisseler@.gmx.net> wrote in message
> news:2lk43sFd4pjhU1@.uni-berlin.de...
> I
> password.
> can
> but
> started.
> not
>
|||Yeah, exactly that's it! The TCP/IP was disabled. I don't now why but after
I startet again, it works fine.
1000 thanks to you...
Dani
1000 thanks
"Dylan kruger" <carmellobear1@.hotmail.com> schrieb im Newsbeitrag
news:eC7EjuaaEHA.3112@.tk2msftngp13.phx.gbl...
> If you run svrnetcn.exe from the /Program Files/Microsoft SQL
> Server/80/Tools/BINN folder it will bring up the Server network utility,
you[vbcol=seagreen]
> can make sure the network libraries are enabled.
> HTH
> Dylan Kruger
> "Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
> news:eGyjL5ZaEHA.1048@.tk2msftngp13.phx.gbl...
MSDE2000A[vbcol=seagreen]
it
>
|||It's a new feature of MSDE, that by default it doesn't act like any other
server application on earth.
Go figure.
Probably Microsoft's tired of hearing people XXXXX about being
wormed/hacked/infected, and they just say, "Fine, your XXX get's no
connectivity anymore. Suck it!"
"Daniel Geisseler" <d.geisseler@.gmx.net> wrote in message
news:2lmm2oFept7kU1@.uni-berlin.de...
> Yeah, exactly that's it! The TCP/IP was disabled. I don't now why but
after[vbcol=seagreen]
> I startet again, it works fine.
> 1000 thanks to you...
> Dani
>
> 1000 thanks
> "Dylan kruger" <carmellobear1@.hotmail.com> schrieb im Newsbeitrag
> news:eC7EjuaaEHA.3112@.tk2msftngp13.phx.gbl...
> you
> MSDE2000A
think[vbcol=seagreen]
machine[vbcol=seagreen]
> it
I[vbcol=seagreen]
'DBVisualizer')[vbcol=seagreen]
but
>
|||I had a similar problem - I was not able to connect to the MSDE from
any other machine. I had tried openning the TCP/IP Port (1433) and even
shutting down the Firewall.
Eventually, I was able to able to fix the issue by adding the registry
value for "ProtocolList" under HKEY_LOCAL_MACHINE -> SOFTWARE ->
Microsoft -> MSSQLServer -> SuperSocketNetLib
But now I have a different issue. How can I connect to the MSDE
instance with DBVisualizer? I tried to create a connection but when I
try to select / edit a Driver the drop down is empty and I cannot get
one from the list that I get by hitting the Edit button.
Please help.
- manzoor
Tuesday, March 20, 2012
Can't extract key with rskeymgmt
I'm trying to move my RS from one machine to another. Following the MS
instructions found on
http://support.microsoft.com/?kbid=842425, it says to extract the
encryption key. When I try that, i get
C:>rskeymgmt.exe -e -f c:\rskey.txt -p thepassword
Are you sure you want to extract the key from the report server (Y/N)?
y
The local NT Service is disabled 0x80090005
What service would that be? I've seen similar posts with no
resolution. thanks in advance,
steveIhave the same problem
windows 2003 with SP1 and RS 2000 with SP2
any advice?
"sfp" wrote:
> I'm trying to move my RS from one machine to another. Following the MS
> instructions found on
> http://support.microsoft.com/?kbid=842425, it says to extract the
> encryption key. When I try that, i get
> C:>rskeymgmt.exe -e -f c:\rskey.txt -p thepassword
> Are you sure you want to extract the key from the report server (Y/N)?
> y
> The local NT Service is disabled 0x80090005
> What service would that be? I've seen similar posts with no
> resolution. thanks in advance,
> steve
>|||Unfortunately, no. I could not find a solution so I gave up. I
recreated manually. I'd be interested to hear if you find a solution
tho!
Cheers,
Steve
Josky wrote:
> Ihave the same problem
> windows 2003 with SP1 and RS 2000 with SP2
> any advice?
> "sfp" wrote:
> > I'm trying to move my RS from one machine to another. Following the MS
> > instructions found on
> > http://support.microsoft.com/?kbid=842425, it says to extract the
> > encryption key. When I try that, i get
> >
> > C:>rskeymgmt.exe -e -f c:\rskey.txt -p thepassword
> > Are you sure you want to extract the key from the report server (Y/N)?
> > y
> >
> > The local NT Service is disabled 0x80090005
> >
> > What service would that be? I've seen similar posts with no
> > resolution. thanks in advance,
> >
> > steve
> >
> >|||Switch the Account of the Rport Server Service to "NETWORK SERVICE" before
you backup the Key.sql
instructions found on
http://support.microsoft.com/?kbid=842425, it says to extract the
encryption key. When I try that, i get
C:>rskeymgmt.exe -e -f c:\rskey.txt -p thepassword
Are you sure you want to extract the key from the report server (Y/N)?
y
The local NT Service is disabled 0x80090005
What service would that be? I've seen similar posts with no
resolution. thanks in advance,
steveIhave the same problem
windows 2003 with SP1 and RS 2000 with SP2
any advice?
"sfp" wrote:
> I'm trying to move my RS from one machine to another. Following the MS
> instructions found on
> http://support.microsoft.com/?kbid=842425, it says to extract the
> encryption key. When I try that, i get
> C:>rskeymgmt.exe -e -f c:\rskey.txt -p thepassword
> Are you sure you want to extract the key from the report server (Y/N)?
> y
> The local NT Service is disabled 0x80090005
> What service would that be? I've seen similar posts with no
> resolution. thanks in advance,
> steve
>|||Unfortunately, no. I could not find a solution so I gave up. I
recreated manually. I'd be interested to hear if you find a solution
tho!
Cheers,
Steve
Josky wrote:
> Ihave the same problem
> windows 2003 with SP1 and RS 2000 with SP2
> any advice?
> "sfp" wrote:
> > I'm trying to move my RS from one machine to another. Following the MS
> > instructions found on
> > http://support.microsoft.com/?kbid=842425, it says to extract the
> > encryption key. When I try that, i get
> >
> > C:>rskeymgmt.exe -e -f c:\rskey.txt -p thepassword
> > Are you sure you want to extract the key from the report server (Y/N)?
> > y
> >
> > The local NT Service is disabled 0x80090005
> >
> > What service would that be? I've seen similar posts with no
> > resolution. thanks in advance,
> >
> > steve
> >
> >|||Switch the Account of the Rport Server Service to "NETWORK SERVICE" before
you backup the Key.sql
Can't expand localhost icon...
Hi all,
Something that should have been straightforward turned out to be rather
problematic. Thankfully this is only a test machine. SQL Server 2000 Dev
Edition on XP Pro.
I detached a [BLAH] database file with Enterprise Manager, deleted the
corresponding BLAH.MDF/.LDF files, copied newer versions of those files from
another machine where the old files used to be, then was going to reattach
as usual with the following sequence:
Reload SQL Server Enterprise Manager
Expand Microsoft SQL Servers
Expand SQL Server Group
Try to expand (local)
At this point I got the following:
"Unable to connect to server localhost: Server: Msg 4064, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open user
default
database. Login failed."
WTF? I didn't delete any other file, or detach any other database...I'm
ruling out any problem with the newer .MDF/.LDF files, because I'm not even
getting to the point where I can even try to reattach.
Ideas?Argh...never mind...I just found Q307864. No clue why Google failed to
return it the first time around (*before* I posted my original question)...
I still have no idea though why the problem started...|||Homer,
That error message is normal.Iam assuming that the login uses the same
database that you detached, as the default one.While you were connecting to
the server through EM, the login failed since the default database was not
online.
Use master as default database to avoid situations like this.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Homer J. Simpson" <root@.127.0.0.1> wrote in message
news:uRT3WfsLEHA.644@.tk2msftngp13.phx.gbl...
> Hi all,
> Something that should have been straightforward turned out to be rather
> problematic. Thankfully this is only a test machine. SQL Server 2000 Dev
> Edition on XP Pro.
> I detached a [BLAH] database file with Enterprise Manager, deleted the
> corresponding BLAH.MDF/.LDF files, copied newer versions of those files
from
> another machine where the old files used to be, then was going to reattach
> as usual with the following sequence:
> Reload SQL Server Enterprise Manager
> Expand Microsoft SQL Servers
> Expand SQL Server Group
> Try to expand (local)
> At this point I got the following:
> "Unable to connect to server localhost: Server: Msg 4064, Level 16, State
1
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open use
r default
> database. Login failed."
> WTF? I didn't delete any other file, or detach any other database...I'm
> ruling out any problem with the newer .MDF/.LDF files, because I'm not
even
> getting to the point where I can even try to reattach.
> Ideas?
>|||"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:%23tKHyvtLEHA.892@.TK2MSFTNGP09.phx.gbl...
> Homer,
> That error message is normal.Iam assuming that the login uses the same
> database that you detached, as the default one.While you were connecting
to
> the server through EM, the login failed since the default database was not
> online.
> Use master as default database to avoid situations like this.
It's very possible this is the case--I can't remember...however I use this
particular database almost exclusively on this test machine, so I can see
how I might have changed the default at some point...|||Hi Homer,
I am reviewing your post now. I want to know that after you change the
default database of all users to MASTER, is the problem resolved? Please
feel free to let us know that if you still have any problem. We are glad to
help.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.sql
Something that should have been straightforward turned out to be rather
problematic. Thankfully this is only a test machine. SQL Server 2000 Dev
Edition on XP Pro.
I detached a [BLAH] database file with Enterprise Manager, deleted the
corresponding BLAH.MDF/.LDF files, copied newer versions of those files from
another machine where the old files used to be, then was going to reattach
as usual with the following sequence:
Reload SQL Server Enterprise Manager
Expand Microsoft SQL Servers
Expand SQL Server Group
Try to expand (local)
At this point I got the following:
"Unable to connect to server localhost: Server: Msg 4064, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open user
default
database. Login failed."
WTF? I didn't delete any other file, or detach any other database...I'm
ruling out any problem with the newer .MDF/.LDF files, because I'm not even
getting to the point where I can even try to reattach.
Ideas?Argh...never mind...I just found Q307864. No clue why Google failed to
return it the first time around (*before* I posted my original question)...
I still have no idea though why the problem started...|||Homer,
That error message is normal.Iam assuming that the login uses the same
database that you detached, as the default one.While you were connecting to
the server through EM, the login failed since the default database was not
online.
Use master as default database to avoid situations like this.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Homer J. Simpson" <root@.127.0.0.1> wrote in message
news:uRT3WfsLEHA.644@.tk2msftngp13.phx.gbl...
> Hi all,
> Something that should have been straightforward turned out to be rather
> problematic. Thankfully this is only a test machine. SQL Server 2000 Dev
> Edition on XP Pro.
> I detached a [BLAH] database file with Enterprise Manager, deleted the
> corresponding BLAH.MDF/.LDF files, copied newer versions of those files
from
> another machine where the old files used to be, then was going to reattach
> as usual with the following sequence:
> Reload SQL Server Enterprise Manager
> Expand Microsoft SQL Servers
> Expand SQL Server Group
> Try to expand (local)
> At this point I got the following:
> "Unable to connect to server localhost: Server: Msg 4064, Level 16, State
1
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open use
r default
> database. Login failed."
> WTF? I didn't delete any other file, or detach any other database...I'm
> ruling out any problem with the newer .MDF/.LDF files, because I'm not
even
> getting to the point where I can even try to reattach.
> Ideas?
>|||"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:%23tKHyvtLEHA.892@.TK2MSFTNGP09.phx.gbl...
> Homer,
> That error message is normal.Iam assuming that the login uses the same
> database that you detached, as the default one.While you were connecting
to
> the server through EM, the login failed since the default database was not
> online.
> Use master as default database to avoid situations like this.
It's very possible this is the case--I can't remember...however I use this
particular database almost exclusively on this test machine, so I can see
how I might have changed the default at some point...|||Hi Homer,
I am reviewing your post now. I want to know that after you change the
default database of all users to MASTER, is the problem resolved? Please
feel free to let us know that if you still have any problem. We are glad to
help.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.sql
Can't expand localhost icon...
Hi all,
Something that should have been straightforward turned out to be rather
problematic. Thankfully this is only a test machine. SQL Server 2000 Dev
Edition on XP Pro.
I detached a [BLAH] database file with Enterprise Manager, deleted the
corresponding BLAH.MDF/.LDF files, copied newer versions of those files from
another machine where the old files used to be, then was going to reattach
as usual with the following sequence:
Reload SQL Server Enterprise Manager
Expand Microsoft SQL Servers
Expand SQL Server Group
Try to expand (local)
At this point I got the following:
"Unable to connect to server localhost: Server: Msg 4064, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open user default
database. Login failed."
WTF? I didn't delete any other file, or detach any other database...I'm
ruling out any problem with the newer .MDF/.LDF files, because I'm not even
getting to the point where I can even try to reattach.
Ideas?
Argh...never mind...I just found Q307864. No clue why Google failed to
return it the first time around (*before* I posted my original question)...
I still have no idea though why the problem started...
|||Homer,
That error message is normal.Iam assuming that the login uses the same
database that you detached, as the default one.While you were connecting to
the server through EM, the login failed since the default database was not
online.
Use master as default database to avoid situations like this.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Homer J. Simpson" <root@.127.0.0.1> wrote in message
news:uRT3WfsLEHA.644@.tk2msftngp13.phx.gbl...
> Hi all,
> Something that should have been straightforward turned out to be rather
> problematic. Thankfully this is only a test machine. SQL Server 2000 Dev
> Edition on XP Pro.
> I detached a [BLAH] database file with Enterprise Manager, deleted the
> corresponding BLAH.MDF/.LDF files, copied newer versions of those files
from
> another machine where the old files used to be, then was going to reattach
> as usual with the following sequence:
> Reload SQL Server Enterprise Manager
> Expand Microsoft SQL Servers
> Expand SQL Server Group
> Try to expand (local)
> At this point I got the following:
> "Unable to connect to server localhost: Server: Msg 4064, Level 16, State
1
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open user default
> database. Login failed."
> WTF? I didn't delete any other file, or detach any other database...I'm
> ruling out any problem with the newer .MDF/.LDF files, because I'm not
even
> getting to the point where I can even try to reattach.
> Ideas?
>
|||"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:%23tKHyvtLEHA.892@.TK2MSFTNGP09.phx.gbl...
> Homer,
> That error message is normal.Iam assuming that the login uses the same
> database that you detached, as the default one.While you were connecting
to
> the server through EM, the login failed since the default database was not
> online.
> Use master as default database to avoid situations like this.
It's very possible this is the case--I can't remember...however I use this
particular database almost exclusively on this test machine, so I can see
how I might have changed the default at some point...
|||Hi Homer,
I am reviewing your post now. I want to know that after you change the
default database of all users to MASTER, is the problem resolved? Please
feel free to let us know that if you still have any problem. We are glad to
help.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
Something that should have been straightforward turned out to be rather
problematic. Thankfully this is only a test machine. SQL Server 2000 Dev
Edition on XP Pro.
I detached a [BLAH] database file with Enterprise Manager, deleted the
corresponding BLAH.MDF/.LDF files, copied newer versions of those files from
another machine where the old files used to be, then was going to reattach
as usual with the following sequence:
Reload SQL Server Enterprise Manager
Expand Microsoft SQL Servers
Expand SQL Server Group
Try to expand (local)
At this point I got the following:
"Unable to connect to server localhost: Server: Msg 4064, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open user default
database. Login failed."
WTF? I didn't delete any other file, or detach any other database...I'm
ruling out any problem with the newer .MDF/.LDF files, because I'm not even
getting to the point where I can even try to reattach.
Ideas?
Argh...never mind...I just found Q307864. No clue why Google failed to
return it the first time around (*before* I posted my original question)...
I still have no idea though why the problem started...
|||Homer,
That error message is normal.Iam assuming that the login uses the same
database that you detached, as the default one.While you were connecting to
the server through EM, the login failed since the default database was not
online.
Use master as default database to avoid situations like this.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Homer J. Simpson" <root@.127.0.0.1> wrote in message
news:uRT3WfsLEHA.644@.tk2msftngp13.phx.gbl...
> Hi all,
> Something that should have been straightforward turned out to be rather
> problematic. Thankfully this is only a test machine. SQL Server 2000 Dev
> Edition on XP Pro.
> I detached a [BLAH] database file with Enterprise Manager, deleted the
> corresponding BLAH.MDF/.LDF files, copied newer versions of those files
from
> another machine where the old files used to be, then was going to reattach
> as usual with the following sequence:
> Reload SQL Server Enterprise Manager
> Expand Microsoft SQL Servers
> Expand SQL Server Group
> Try to expand (local)
> At this point I got the following:
> "Unable to connect to server localhost: Server: Msg 4064, Level 16, State
1
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open user default
> database. Login failed."
> WTF? I didn't delete any other file, or detach any other database...I'm
> ruling out any problem with the newer .MDF/.LDF files, because I'm not
even
> getting to the point where I can even try to reattach.
> Ideas?
>
|||"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:%23tKHyvtLEHA.892@.TK2MSFTNGP09.phx.gbl...
> Homer,
> That error message is normal.Iam assuming that the login uses the same
> database that you detached, as the default one.While you were connecting
to
> the server through EM, the login failed since the default database was not
> online.
> Use master as default database to avoid situations like this.
It's very possible this is the case--I can't remember...however I use this
particular database almost exclusively on this test machine, so I can see
how I might have changed the default at some point...
|||Hi Homer,
I am reviewing your post now. I want to know that after you change the
default database of all users to MASTER, is the problem resolved? Please
feel free to let us know that if you still have any problem. We are glad to
help.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
Monday, March 19, 2012
Can't deploy from local machine
Can anyone help me. I work in a workgroup environment as opposed to domain
controlled. The minute I do anything with reporting services or analysis
services that is between machines I get problems.
I can't deploy to SSAS or SSRS from my machine unless I log into my machine
with a username and account that is the same as the machine being deployed
to. How do I tell BIDS what credentials to use.
Can anyone give me an overview of how credentials are passed in a non domain
environment.On Sep 25, 2:47 pm, "Fresno Bob" <nos...@.nospam.com> wrote:
> Can anyone help me. I work in a workgroup environment as opposed to domain
> controlled. The minute I do anything with reporting services or analysis
> services that is between machines I get problems.
> I can't deploy to SSAS or SSRS from my machine unless I log into my machine
> with a username and account that is the same as the machine being deployed
> to. How do I tell BIDS what credentials to use.
> Can anyone give me an overview of how credentials are passed in a non domain
> environment.
This article is off topic; however, gives a general explanation
similar to your scenario. http://msdn2.microsoft.com/en-us/library/ms252507(VS.80).aspx
It seems that this is more of an OS security level/authentication
issue. As far as I know, you may not be able to control the BIDS
credentials. At a Report Server level, you should be able to change
credentials once the report is deployed in the Report Mgr. You might
try looking in the ReportProjectName.rptproj.user file to see if you
can possibly modify something there. Sorry that I could not be of
greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||SSAS Requires Windows Authentication to work and does not accept SQL
Authentication. If you are in a workgroup the only way to get your scenario
to work is to create identical local accounts on both machines. When I say
identical I mean has the same name and password. Since you are not in a
domain there isn't a way for the remote server to validate your credentials
and will therefore always get a user of "null".
--
SQL Server Developer Support Engineer
"Fresno Bob" wrote:
> Can anyone help me. I work in a workgroup environment as opposed to domain
> controlled. The minute I do anything with reporting services or analysis
> services that is between machines I get problems.
> I can't deploy to SSAS or SSRS from my machine unless I log into my machine
> with a username and account that is the same as the machine being deployed
> to. How do I tell BIDS what credentials to use.
> Can anyone give me an overview of how credentials are passed in a non domain
> environment.
>
>
controlled. The minute I do anything with reporting services or analysis
services that is between machines I get problems.
I can't deploy to SSAS or SSRS from my machine unless I log into my machine
with a username and account that is the same as the machine being deployed
to. How do I tell BIDS what credentials to use.
Can anyone give me an overview of how credentials are passed in a non domain
environment.On Sep 25, 2:47 pm, "Fresno Bob" <nos...@.nospam.com> wrote:
> Can anyone help me. I work in a workgroup environment as opposed to domain
> controlled. The minute I do anything with reporting services or analysis
> services that is between machines I get problems.
> I can't deploy to SSAS or SSRS from my machine unless I log into my machine
> with a username and account that is the same as the machine being deployed
> to. How do I tell BIDS what credentials to use.
> Can anyone give me an overview of how credentials are passed in a non domain
> environment.
This article is off topic; however, gives a general explanation
similar to your scenario. http://msdn2.microsoft.com/en-us/library/ms252507(VS.80).aspx
It seems that this is more of an OS security level/authentication
issue. As far as I know, you may not be able to control the BIDS
credentials. At a Report Server level, you should be able to change
credentials once the report is deployed in the Report Mgr. You might
try looking in the ReportProjectName.rptproj.user file to see if you
can possibly modify something there. Sorry that I could not be of
greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||SSAS Requires Windows Authentication to work and does not accept SQL
Authentication. If you are in a workgroup the only way to get your scenario
to work is to create identical local accounts on both machines. When I say
identical I mean has the same name and password. Since you are not in a
domain there isn't a way for the remote server to validate your credentials
and will therefore always get a user of "null".
--
SQL Server Developer Support Engineer
"Fresno Bob" wrote:
> Can anyone help me. I work in a workgroup environment as opposed to domain
> controlled. The minute I do anything with reporting services or analysis
> services that is between machines I get problems.
> I can't deploy to SSAS or SSRS from my machine unless I log into my machine
> with a username and account that is the same as the machine being deployed
> to. How do I tell BIDS what credentials to use.
> Can anyone give me an overview of how credentials are passed in a non domain
> environment.
>
>
Friday, February 24, 2012
Can't connect to the sql server
I have machine A hosting SQL Server XXX, and B tries to access XXX. XXX
use mixed authentication mode. A and B are in the same LAN and
workgroup.
B use Sql Server username and passoword to access the XXX sql server.
In ADO.Net and Visual Studio .Net, if I first register the Server A on
Visual Studio .Net IDE, then I can connect to XXX by the pre-set sql
server username and password, otherwise it failed.
Or, if I first connect to Server A by visiting network connections to
give A's windows username and password, then I can connect to XXX by
the pre-set sql server username and password.
However, if I don't first gain access A, then I can't connect XXX by
the pre-set sql server username and password.
What's the problem here?
Thanks;Can you describe your installation more fully? Which edition of SQL
Server 2005 (I assume it's SQL Server 2005) are you using? Which CTP?
Thanks
Andrew Watt
MVP - InfoPath
On 9 Oct 2005 11:55:29 -0700, zhenghong04@.yahoo.com wrote:
>I have machine A hosting SQL Server XXX, and B tries to access XXX. XXX
>use mixed authentication mode. A and B are in the same LAN and
>workgroup.
>B use Sql Server username and passoword to access the XXX sql server.
>In ADO.Net and Visual Studio .Net, if I first register the Server A on
>Visual Studio .Net IDE, then I can connect to XXX by the pre-set sql
>server username and password, otherwise it failed.
>Or, if I first connect to Server A by visiting network connections to
>give A's windows username and password, then I can connect to XXX by
>the pre-set sql server username and password.
>However, if I don't first gain access A, then I can't connect XXX by
>the pre-set sql server username and password.
>What's the problem here?
>Thanks;
use mixed authentication mode. A and B are in the same LAN and
workgroup.
B use Sql Server username and passoword to access the XXX sql server.
In ADO.Net and Visual Studio .Net, if I first register the Server A on
Visual Studio .Net IDE, then I can connect to XXX by the pre-set sql
server username and password, otherwise it failed.
Or, if I first connect to Server A by visiting network connections to
give A's windows username and password, then I can connect to XXX by
the pre-set sql server username and password.
However, if I don't first gain access A, then I can't connect XXX by
the pre-set sql server username and password.
What's the problem here?
Thanks;Can you describe your installation more fully? Which edition of SQL
Server 2005 (I assume it's SQL Server 2005) are you using? Which CTP?
Thanks
Andrew Watt
MVP - InfoPath
On 9 Oct 2005 11:55:29 -0700, zhenghong04@.yahoo.com wrote:
>I have machine A hosting SQL Server XXX, and B tries to access XXX. XXX
>use mixed authentication mode. A and B are in the same LAN and
>workgroup.
>B use Sql Server username and passoword to access the XXX sql server.
>In ADO.Net and Visual Studio .Net, if I first register the Server A on
>Visual Studio .Net IDE, then I can connect to XXX by the pre-set sql
>server username and password, otherwise it failed.
>Or, if I first connect to Server A by visiting network connections to
>give A's windows username and password, then I can connect to XXX by
>the pre-set sql server username and password.
>However, if I don't first gain access A, then I can't connect XXX by
>the pre-set sql server username and password.
>What's the problem here?
>Thanks;
Can't connect to the sql server
I have machine A hosting SQL Server XXX, and B tries to access XXX. XXX
use mixed authentication mode. A and B are in the same LAN and
workgroup.
B use Sql Server username and passoword to access the XXX sql server.
In ADO.Net and Visual Studio .Net, if I first register the Server A on
Visual Studio .Net IDE, then I can connect to XXX by the pre-set sql
server username and password, otherwise it failed.
Or, if I first connect to Server A by visiting network connections to
give A's windows username and password, then I can connect to XXX by
the pre-set sql server username and password.
However, if I don't first gain access A, then I can't connect XXX by
the pre-set sql server username and password.
What's the problem here?
Thanks;
Can you describe your installation more fully? Which edition of SQL
Server 2005 (I assume it's SQL Server 2005) are you using? Which CTP?
Thanks
Andrew Watt
MVP - InfoPath
On 9 Oct 2005 11:55:29 -0700, zhenghong04@.yahoo.com wrote:
>I have machine A hosting SQL Server XXX, and B tries to access XXX. XXX
>use mixed authentication mode. A and B are in the same LAN and
>workgroup.
>B use Sql Server username and passoword to access the XXX sql server.
>In ADO.Net and Visual Studio .Net, if I first register the Server A on
>Visual Studio .Net IDE, then I can connect to XXX by the pre-set sql
>server username and password, otherwise it failed.
>Or, if I first connect to Server A by visiting network connections to
>give A's windows username and password, then I can connect to XXX by
>the pre-set sql server username and password.
>However, if I don't first gain access A, then I can't connect XXX by
>the pre-set sql server username and password.
>What's the problem here?
>Thanks;
use mixed authentication mode. A and B are in the same LAN and
workgroup.
B use Sql Server username and passoword to access the XXX sql server.
In ADO.Net and Visual Studio .Net, if I first register the Server A on
Visual Studio .Net IDE, then I can connect to XXX by the pre-set sql
server username and password, otherwise it failed.
Or, if I first connect to Server A by visiting network connections to
give A's windows username and password, then I can connect to XXX by
the pre-set sql server username and password.
However, if I don't first gain access A, then I can't connect XXX by
the pre-set sql server username and password.
What's the problem here?
Thanks;
Can you describe your installation more fully? Which edition of SQL
Server 2005 (I assume it's SQL Server 2005) are you using? Which CTP?
Thanks
Andrew Watt
MVP - InfoPath
On 9 Oct 2005 11:55:29 -0700, zhenghong04@.yahoo.com wrote:
>I have machine A hosting SQL Server XXX, and B tries to access XXX. XXX
>use mixed authentication mode. A and B are in the same LAN and
>workgroup.
>B use Sql Server username and passoword to access the XXX sql server.
>In ADO.Net and Visual Studio .Net, if I first register the Server A on
>Visual Studio .Net IDE, then I can connect to XXX by the pre-set sql
>server username and password, otherwise it failed.
>Or, if I first connect to Server A by visiting network connections to
>give A's windows username and password, then I can connect to XXX by
>the pre-set sql server username and password.
>However, if I don't first gain access A, then I can't connect XXX by
>the pre-set sql server username and password.
>What's the problem here?
>Thanks;
Can't connect to SS2005
Hello,
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
Thanks in advance,
sck10
Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>
|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
[vbcol=seagreen]
> --
Once[vbcol=seagreen]
> I
|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there[vbcol=seagreen]
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>browser"
Add/Remove
>Once
>
>
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
Thanks in advance,
sck10
Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>
|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
[vbcol=seagreen]
> --
Once[vbcol=seagreen]
> I
|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there[vbcol=seagreen]
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>browser"
Add/Remove
>Once
>
>
Can't connect to SS2005
Hello,
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
--
Thanks in advance,
sck10Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
--
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
--
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> --
> >From: "sck10" <sck10@.online.nospam>
> >Hello,
> >
> >I had SS2K running on my local machine (everything worked). Then I
> >installed SS2005 and was able to connect the server running locally.
Once
> I
> >uninstalled SQL Server 2000, I was unable to connect. Even if I try to
> >create a new registration, I get the error that I can't connect to the
> >server. Any help with this would be greatly appreciated.
> >
> >--
> >Thanks in advance,
> >
> >sck10|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>> Hello,
>> It seems issues in client tools. You may want to check "sql server
>browser"
>> service is started. Also, please remove/reinstall SQL tools via
Add/Remove
>> programs to test the situation.
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> --
>> >From: "sck10" <sck10@.online.nospam>
>> >Hello,
>> >
>> >I had SS2K running on my local machine (everything worked). Then I
>> >installed SS2005 and was able to connect the server running locally.
>Once
>> I
>> >uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>> >create a new registration, I get the error that I can't connect to the
>> >server. Any help with this would be greatly appreciated.
>> >
>> >--
>> >Thanks in advance,
>> >
>> >sck10
>
>
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
--
Thanks in advance,
sck10Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
--
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
--
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> --
> >From: "sck10" <sck10@.online.nospam>
> >Hello,
> >
> >I had SS2K running on my local machine (everything worked). Then I
> >installed SS2005 and was able to connect the server running locally.
Once
> I
> >uninstalled SQL Server 2000, I was unable to connect. Even if I try to
> >create a new registration, I get the error that I can't connect to the
> >server. Any help with this would be greatly appreciated.
> >
> >--
> >Thanks in advance,
> >
> >sck10|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>> Hello,
>> It seems issues in client tools. You may want to check "sql server
>browser"
>> service is started. Also, please remove/reinstall SQL tools via
Add/Remove
>> programs to test the situation.
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> --
>> >From: "sck10" <sck10@.online.nospam>
>> >Hello,
>> >
>> >I had SS2K running on my local machine (everything worked). Then I
>> >installed SS2005 and was able to connect the server running locally.
>Once
>> I
>> >uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>> >create a new registration, I get the error that I can't connect to the
>> >server. Any help with this would be greatly appreciated.
>> >
>> >--
>> >Thanks in advance,
>> >
>> >sck10
>
>
Can't connect to SS2005
Hello,
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
Thanks in advance,
sck10Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
--
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
--
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
[vbcol=seagreen]
> --
Once[vbcol=seagreen]
> I|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>browser"
Add/Remove[vbcol=seagreen]
>
>Once
>
>
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
Thanks in advance,
sck10Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
--
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
--
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
[vbcol=seagreen]
> --
Once[vbcol=seagreen]
> I|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>browser"
Add/Remove[vbcol=seagreen]
>
>Once
>
>
Sunday, February 19, 2012
Can't connect to SQL Server 2005 Express from another machine
I know there have been many posts made on this subject; however, despite the resources available, I have not been able to get this to work! I've spent time working on this here and there over the last couple of months only resulting in frustration. I am finally posting to solicit help for my situation to figure out what is wrong with my SQL Server or firewall configuration.
Two machines connected to a router, one wireless, one wired. Both have SQL Server Express and the Management Studio tools installed. From either machine I can connect to its local SQL Server Express instance.
I have enabled Shared Memory, Named Pipes, TCP/IP, and VIA in the SQL Server Configuration Manager. (BTW what is VIA?)
I have added sqlsrvr.exe and sqlbrowser.exe to my Windows Firewall exceptions. I have tried disabling Windows Firewall. One of the machines is configured as DMZ in the router configuration.
Please, someone offer up some brilliant diagnostic steps I am missing to expose what is wrong in my setup and make this work... Thank you!
BTW, here is the error message. You can see why, in light of what I mentioned above, this error message is infuriating to me by now... !
Cannot connect to \\remotemachine\sqlexpress.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 5 - Invalid parameter(s) found) (Microsoft SQL Server, Error: 87)
HResult 0x57, Level 16, State 1
Named Pipes Provider: Invalid parameter(s) found [87].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
Can you connect to the system by configuring an ODBC Connection from the ODBC Manager in the control panel. Doing this will help to verify where the problem is... if it goes through there is a problem in the way that you app is connecting to the database.
I see that you are connecting by names pipes... when trying the connection try by using tcpip to connect.
|||Thanks for the response. I get the same results from the ODBC Manager as I do from the Management Studio, command line, or from an application. Can't connect, same error message.
I can't believe I forgot to mention this in my original post, but even when I try to connect to the local SQL Server instance using it's IP address 192.168.0.98 instead of 127.0.0.1... I get the error message above. Hope this sparks some ideas out there. Thanks!
|||Did you check the surface area configuration? By default, SQL Server 2005 (even if it's just express edition) is secured so you need to configure access.|||bass_player wrote:
Did you check the surface area configuration? By default, SQL Server 2005 (even if it's just express edition) is secured so you need to configure access.
The surface area configuration shows that it is configured for local and remote connections using both TCP/IP and named pipes. Thanks though. I am baffled.
|||Maybe this has something to do with it?
Under SQL Server Configuration Manager TCP/IP Properties, it shows IP1, IP2, IP3 and IPAll. IP3 is an old IP address from when the machine was configured to use DHCP (can this entry be deleted somehow?). IP2 is 127.0.0.1, which I can connect on. IP1 is 192.168.0.98 which I want to connect with. IP1's "Active" property seems to keep getting set to "No", even after I set it to "Yes" and restart SQL Server. What do you think about this?
|||I connected. I am an idiot.
Once I tried with the correct freakin' IP address AND explicitly with the port, I can connect.
It's 192.168.1.98 not 192.168.0.98. That entry in the TCP/IP Properties (which was 0) was faking me out.
Woohoo! :)
Sorry folks. Thanks for the responses.
Cant connect to SQL server 2000.....
I have SQL server 2000 installed on machine A and when I try to connect using machine B, I get the error message:
A connection could not be established to "servername"
Reson: Timeout expired.
I have been able to connect to the machine in the past and this morning, the server was rebooted and now I can't connect. I can see the server using enterprise manager and I can start and stop machine A from B, but I just can't connect. Any ideas?
ThanksLots of places to start checking, but try the SQL Server Error logs first. Look for the following entries:
2006-01-26 11:09:34.59 server Using 'SSNETLIB.DLL' version '8.0.2039'.
...
2006-01-26 11:09:34.62 server SQL server listening on xx.xx.xx.xx: 1433.
2006-01-26 11:09:34.62 server SQL server listening on 127.0.0.1: 1433.
2006-01-26 11:09:34.71 spid3 Server name is 'MYSERVER'.
...
2006-01-26 11:09:35.62 server SQL server listening on TCP, Shared Memory, Named Pipes.
2006-01-26 11:09:35.73 server SQL Server is ready for client connections
If something is amiss here, google the error message and start from there.
Next try telnetting to your server's ip address on port 1433 (or whatever port SQL says it's listening on). From a command window, type telnet MyServer 1433. The command window should blink, go entirely black and nothing else. If you get a response like 'cannot connect', then there are network issues (or the SQL Server service is not started.
Try starting there...
Regards,
hmscott
A connection could not be established to "servername"
Reson: Timeout expired.
I have been able to connect to the machine in the past and this morning, the server was rebooted and now I can't connect. I can see the server using enterprise manager and I can start and stop machine A from B, but I just can't connect. Any ideas?
ThanksLots of places to start checking, but try the SQL Server Error logs first. Look for the following entries:
2006-01-26 11:09:34.59 server Using 'SSNETLIB.DLL' version '8.0.2039'.
...
2006-01-26 11:09:34.62 server SQL server listening on xx.xx.xx.xx: 1433.
2006-01-26 11:09:34.62 server SQL server listening on 127.0.0.1: 1433.
2006-01-26 11:09:34.71 spid3 Server name is 'MYSERVER'.
...
2006-01-26 11:09:35.62 server SQL server listening on TCP, Shared Memory, Named Pipes.
2006-01-26 11:09:35.73 server SQL Server is ready for client connections
If something is amiss here, google the error message and start from there.
Next try telnetting to your server's ip address on port 1433 (or whatever port SQL says it's listening on). From a command window, type telnet MyServer 1433. The command window should blink, go entirely black and nothing else. If you get a response like 'cannot connect', then there are network issues (or the SQL Server service is not started.
Try starting there...
Regards,
hmscott
Can't connect to SQL Server (developer edition) from another PC?
I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
SP2 machine. It's installed without any problems.
When I try to connect to it from another XP SP2 machine (by creating
an ODBC data source) I get a Login error:
[ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
Connection failed: SQLState: 08001 SQL Server Error: 17
SQL Server does not exist or access denied
I can ping the server fine from the other machine, and I've tried the
standard "sa" user/pw as welll as my own logins.
The server is configured for mixed authentication (Windows/SQL
Server).
Can anyone suggest what the problem might be?
TIA for any help
Ian
Are you running XP firewall on that machine? If so, turn it off and any
other firewall (Norton Internet Security, etc).
Chris
"ITM" <itm@.nospam.com> wrote in message
news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com...
> I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
> SP2 machine. It's installed without any problems.
> When I try to connect to it from another XP SP2 machine (by creating
> an ODBC data source) I get a Login error:
> [ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
> Connection failed: SQLState: 08001 SQL Server Error: 17
> SQL Server does not exist or access denied
> I can ping the server fine from the other machine, and I've tried the
> standard "sa" user/pw as welll as my own logins.
> The server is configured for mixed authentication (Windows/SQL
> Server).
> Can anyone suggest what the problem might be?
> TIA for any help
> Ian
|||On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
<schmidtc@.KvalleyDotCom> wrote:
>Are you running XP firewall on that machine? If so, turn it off and any
>other firewall (Norton Internet Security, etc).
>Chris
>"ITM" <itm@.nospam.com> wrote in message
>news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com.. .
>
I've tried turning off XP firewall but it made no difference. I'm not
running Norton, but am using AVG anti-virus (free edition). No other
firewall/AV software installed.
Ian
|||What happens when you telnet to port 1433 on that machine (or whatever port
you're running it on)?
Chris
"ITM" <itm@.nospam.com> wrote in message
news:0qbr315sngsoq0eh8eook7v1t5k3d5bcsr@.4ax.com...
> On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
> <schmidtc@.KvalleyDotCom> wrote:
> I've tried turning off XP firewall but it made no difference. I'm not
> running Norton, but am using AVG anti-virus (free edition). No other
> firewall/AV software installed.
> Ian
|||On Sun, 20 Mar 2005 09:41:09 -0800, "Chris Schmidt"
<schmidtc@.KvalleyDotCom> wrote:
>What happens when you telnet to port 1433 on that machine (or whatever port
>you're running it on)?
>Chris
>"ITM" <itm@.nospam.com> wrote in message
>news:0qbr315sngsoq0eh8eook7v1t5k3d5bcsr@.4ax.com.. .
>
Have just downloaded and installed SP3 for SQL Server - it seems to
have done the trick. Should've tried that before :-(
SP2 machine. It's installed without any problems.
When I try to connect to it from another XP SP2 machine (by creating
an ODBC data source) I get a Login error:
[ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
Connection failed: SQLState: 08001 SQL Server Error: 17
SQL Server does not exist or access denied
I can ping the server fine from the other machine, and I've tried the
standard "sa" user/pw as welll as my own logins.
The server is configured for mixed authentication (Windows/SQL
Server).
Can anyone suggest what the problem might be?
TIA for any help
Ian
Are you running XP firewall on that machine? If so, turn it off and any
other firewall (Norton Internet Security, etc).
Chris
"ITM" <itm@.nospam.com> wrote in message
news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com...
> I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
> SP2 machine. It's installed without any problems.
> When I try to connect to it from another XP SP2 machine (by creating
> an ODBC data source) I get a Login error:
> [ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
> Connection failed: SQLState: 08001 SQL Server Error: 17
> SQL Server does not exist or access denied
> I can ping the server fine from the other machine, and I've tried the
> standard "sa" user/pw as welll as my own logins.
> The server is configured for mixed authentication (Windows/SQL
> Server).
> Can anyone suggest what the problem might be?
> TIA for any help
> Ian
|||On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
<schmidtc@.KvalleyDotCom> wrote:
>Are you running XP firewall on that machine? If so, turn it off and any
>other firewall (Norton Internet Security, etc).
>Chris
>"ITM" <itm@.nospam.com> wrote in message
>news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com.. .
>
I've tried turning off XP firewall but it made no difference. I'm not
running Norton, but am using AVG anti-virus (free edition). No other
firewall/AV software installed.
Ian
|||What happens when you telnet to port 1433 on that machine (or whatever port
you're running it on)?
Chris
"ITM" <itm@.nospam.com> wrote in message
news:0qbr315sngsoq0eh8eook7v1t5k3d5bcsr@.4ax.com...
> On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
> <schmidtc@.KvalleyDotCom> wrote:
> I've tried turning off XP firewall but it made no difference. I'm not
> running Norton, but am using AVG anti-virus (free edition). No other
> firewall/AV software installed.
> Ian
|||On Sun, 20 Mar 2005 09:41:09 -0800, "Chris Schmidt"
<schmidtc@.KvalleyDotCom> wrote:
>What happens when you telnet to port 1433 on that machine (or whatever port
>you're running it on)?
>Chris
>"ITM" <itm@.nospam.com> wrote in message
>news:0qbr315sngsoq0eh8eook7v1t5k3d5bcsr@.4ax.com.. .
>
Have just downloaded and installed SP3 for SQL Server - it seems to
have done the trick. Should've tried that before :-(
Can't connect to SQL Server (developer edition) from another PC?
I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
SP2 machine. It's installed without any problems.
When I try to connect to it from another XP SP2 machine (by creating
an ODBC data source) I get a Login error:
[ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
Connection failed: SQLState: 08001 SQL Server Error: 17
SQL Server does not exist or access denied
I can ping the server fine from the other machine, and I've tried the
standard "sa" user/pw as welll as my own logins.
The server is configured for mixed authentication (Windows/SQL
Server).
Can anyone suggest what the problem might be?
TIA for any help
IanAre you running XP firewall on that machine? If so, turn it off and any
other firewall (Norton Internet Security, etc).
Chris
"ITM" <itm@.nospam.com> wrote in message
news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com...
> I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
> SP2 machine. It's installed without any problems.
> When I try to connect to it from another XP SP2 machine (by creating
> an ODBC data source) I get a Login error:
> [ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
> Connection failed: SQLState: 08001 SQL Server Error: 17
> SQL Server does not exist or access denied
> I can ping the server fine from the other machine, and I've tried the
> standard "sa" user/pw as welll as my own logins.
> The server is configured for mixed authentication (Windows/SQL
> Server).
> Can anyone suggest what the problem might be?
> TIA for any help
> Ian|||On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
<schmidtc@.KvalleyDotCom> wrote:
>Are you running XP firewall on that machine? If so, turn it off and any
>other firewall (Norton Internet Security, etc).
>Chris
>"ITM" <itm@.nospam.com> wrote in message
>news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com...
>> I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
>> SP2 machine. It's installed without any problems.
>> When I try to connect to it from another XP SP2 machine (by creating
>> an ODBC data source) I get a Login error:
>> [ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
>> Connection failed: SQLState: 08001 SQL Server Error: 17
>> SQL Server does not exist or access denied
>> I can ping the server fine from the other machine, and I've tried the
>> standard "sa" user/pw as welll as my own logins.
>> The server is configured for mixed authentication (Windows/SQL
>> Server).
>> Can anyone suggest what the problem might be?
>> TIA for any help
>> Ian
>
I've tried turning off XP firewall but it made no difference. I'm not
running Norton, but am using AVG anti-virus (free edition). No other
firewall/AV software installed.
Ian|||What happens when you telnet to port 1433 on that machine (or whatever port
you're running it on)?
Chris
"ITM" <itm@.nospam.com> wrote in message
news:0qbr315sngsoq0eh8eook7v1t5k3d5bcsr@.4ax.com...
> On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
> <schmidtc@.KvalleyDotCom> wrote:
>>Are you running XP firewall on that machine? If so, turn it off and any
>>other firewall (Norton Internet Security, etc).
>>Chris
>>"ITM" <itm@.nospam.com> wrote in message
>>news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com...
>> I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
>> SP2 machine. It's installed without any problems.
>> When I try to connect to it from another XP SP2 machine (by creating
>> an ODBC data source) I get a Login error:
>> [ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
>> Connection failed: SQLState: 08001 SQL Server Error: 17
>> SQL Server does not exist or access denied
>> I can ping the server fine from the other machine, and I've tried the
>> standard "sa" user/pw as welll as my own logins.
>> The server is configured for mixed authentication (Windows/SQL
>> Server).
>> Can anyone suggest what the problem might be?
>> TIA for any help
>> Ian
> I've tried turning off XP firewall but it made no difference. I'm not
> running Norton, but am using AVG anti-virus (free edition). No other
> firewall/AV software installed.
> Ian|||On Sun, 20 Mar 2005 09:41:09 -0800, "Chris Schmidt"
<schmidtc@.KvalleyDotCom> wrote:
>What happens when you telnet to port 1433 on that machine (or whatever port
>you're running it on)?
>Chris
>"ITM" <itm@.nospam.com> wrote in message
>news:0qbr315sngsoq0eh8eook7v1t5k3d5bcsr@.4ax.com...
>> On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
>> <schmidtc@.KvalleyDotCom> wrote:
>>Are you running XP firewall on that machine? If so, turn it off and any
>>other firewall (Norton Internet Security, etc).
>>Chris
>>"ITM" <itm@.nospam.com> wrote in message
>>news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com...
>> I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
>> SP2 machine. It's installed without any problems.
>> When I try to connect to it from another XP SP2 machine (by creating
>> an ODBC data source) I get a Login error:
>> [ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
>> Connection failed: SQLState: 08001 SQL Server Error: 17
>> SQL Server does not exist or access denied
>> I can ping the server fine from the other machine, and I've tried the
>> standard "sa" user/pw as welll as my own logins.
>> The server is configured for mixed authentication (Windows/SQL
>> Server).
>> Can anyone suggest what the problem might be?
>> TIA for any help
>> Ian
>> I've tried turning off XP firewall but it made no difference. I'm not
>> running Norton, but am using AVG anti-virus (free edition). No other
>> firewall/AV software installed.
>> Ian
>
Have just downloaded and installed SP3 for SQL Server - it seems to
have done the trick. Should've tried that before :-(
SP2 machine. It's installed without any problems.
When I try to connect to it from another XP SP2 machine (by creating
an ODBC data source) I get a Login error:
[ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
Connection failed: SQLState: 08001 SQL Server Error: 17
SQL Server does not exist or access denied
I can ping the server fine from the other machine, and I've tried the
standard "sa" user/pw as welll as my own logins.
The server is configured for mixed authentication (Windows/SQL
Server).
Can anyone suggest what the problem might be?
TIA for any help
IanAre you running XP firewall on that machine? If so, turn it off and any
other firewall (Norton Internet Security, etc).
Chris
"ITM" <itm@.nospam.com> wrote in message
news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com...
> I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
> SP2 machine. It's installed without any problems.
> When I try to connect to it from another XP SP2 machine (by creating
> an ODBC data source) I get a Login error:
> [ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
> Connection failed: SQLState: 08001 SQL Server Error: 17
> SQL Server does not exist or access denied
> I can ping the server fine from the other machine, and I've tried the
> standard "sa" user/pw as welll as my own logins.
> The server is configured for mixed authentication (Windows/SQL
> Server).
> Can anyone suggest what the problem might be?
> TIA for any help
> Ian|||On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
<schmidtc@.KvalleyDotCom> wrote:
>Are you running XP firewall on that machine? If so, turn it off and any
>other firewall (Norton Internet Security, etc).
>Chris
>"ITM" <itm@.nospam.com> wrote in message
>news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com...
>> I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
>> SP2 machine. It's installed without any problems.
>> When I try to connect to it from another XP SP2 machine (by creating
>> an ODBC data source) I get a Login error:
>> [ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
>> Connection failed: SQLState: 08001 SQL Server Error: 17
>> SQL Server does not exist or access denied
>> I can ping the server fine from the other machine, and I've tried the
>> standard "sa" user/pw as welll as my own logins.
>> The server is configured for mixed authentication (Windows/SQL
>> Server).
>> Can anyone suggest what the problem might be?
>> TIA for any help
>> Ian
>
I've tried turning off XP firewall but it made no difference. I'm not
running Norton, but am using AVG anti-virus (free edition). No other
firewall/AV software installed.
Ian|||What happens when you telnet to port 1433 on that machine (or whatever port
you're running it on)?
Chris
"ITM" <itm@.nospam.com> wrote in message
news:0qbr315sngsoq0eh8eook7v1t5k3d5bcsr@.4ax.com...
> On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
> <schmidtc@.KvalleyDotCom> wrote:
>>Are you running XP firewall on that machine? If so, turn it off and any
>>other firewall (Norton Internet Security, etc).
>>Chris
>>"ITM" <itm@.nospam.com> wrote in message
>>news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com...
>> I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
>> SP2 machine. It's installed without any problems.
>> When I try to connect to it from another XP SP2 machine (by creating
>> an ODBC data source) I get a Login error:
>> [ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
>> Connection failed: SQLState: 08001 SQL Server Error: 17
>> SQL Server does not exist or access denied
>> I can ping the server fine from the other machine, and I've tried the
>> standard "sa" user/pw as welll as my own logins.
>> The server is configured for mixed authentication (Windows/SQL
>> Server).
>> Can anyone suggest what the problem might be?
>> TIA for any help
>> Ian
> I've tried turning off XP firewall but it made no difference. I'm not
> running Norton, but am using AVG anti-virus (free edition). No other
> firewall/AV software installed.
> Ian|||On Sun, 20 Mar 2005 09:41:09 -0800, "Chris Schmidt"
<schmidtc@.KvalleyDotCom> wrote:
>What happens when you telnet to port 1433 on that machine (or whatever port
>you're running it on)?
>Chris
>"ITM" <itm@.nospam.com> wrote in message
>news:0qbr315sngsoq0eh8eook7v1t5k3d5bcsr@.4ax.com...
>> On Sun, 20 Mar 2005 08:59:30 -0800, "Chris Schmidt"
>> <schmidtc@.KvalleyDotCom> wrote:
>>Are you running XP firewall on that machine? If so, turn it off and any
>>other firewall (Norton Internet Security, etc).
>>Chris
>>"ITM" <itm@.nospam.com> wrote in message
>>news:te7r31d7sh1bof34mmpcegt5p151jc87ac@.4ax.com...
>> I've installed SQL Server 2000 Developer Edition on a Windows XP Pro
>> SP2 machine. It's installed without any problems.
>> When I try to connect to it from another XP SP2 machine (by creating
>> an ODBC data source) I get a Login error:
>> [ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
>> Connection failed: SQLState: 08001 SQL Server Error: 17
>> SQL Server does not exist or access denied
>> I can ping the server fine from the other machine, and I've tried the
>> standard "sa" user/pw as welll as my own logins.
>> The server is configured for mixed authentication (Windows/SQL
>> Server).
>> Can anyone suggest what the problem might be?
>> TIA for any help
>> Ian
>> I've tried turning off XP firewall but it made no difference. I'm not
>> running Norton, but am using AVG anti-virus (free edition). No other
>> firewall/AV software installed.
>> Ian
>
Have just downloaded and installed SP3 for SQL Server - it seems to
have done the trick. Should've tried that before :-(
Subscribe to:
Posts (Atom)