| Author |
Topic |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2004-06-30 : 10:18:57
|
| For years I've had a server registration using sql server auth set up...now it's failing...can't be found not suthed BS...I can still see mu other boxes in sql mode, and otyhers in mixed, and I can still see my remote boxes in Ireland and Pennysylvania...we're in NJ..The person next to me does the same thing, had to reboot, but was fine.I get ice in the winter...bizzare-o world.Any ideas?Never seen anything like it...I do know that our tech group has been doing some pushes lately...but I checked my settings and they seem fine..but why would I be able to see everything else but this one instance?Brett8-) |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-30 : 12:05:17
|
| How come after 2 years, all of sudden get the message does not exists or not authed?The person next to me..suing the same login has no trouble.I can ping the box with both IP and DNS, and I can map to it in explorer...I can even get access to another box in the same glass house....The helpless desk is sending someone...oh this is good...Brett8-) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-30 : 13:17:08
|
| What is the error?Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-30 : 15:01:03
|
Which one?The original One I tried to connect was SQL Server unknown or Not authorized...Then I wen to dos to do osql...same thing...Then I said ah, how about bcp..then I got....quote:
CTLIB Message: - L6/O8/S5/N3/5/0:ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.Establishing connection failed.
Then someone asked If I installed sybase..."well yes, about 2 months ago"And it seemed like desktop "support" did a push to apply a patch last week, when all hell broke out...mind you I can still connect to prod which are on the same network..prbably sitting right next to each other...ok then...an aliasing we will go....changed the order of protocoals from pipies as the primary to tcp/ip as the primary..and presto...It worked...why? I have no idea...when I try the bcp again from dos, I know get a different error[quote]C:\Program Files\Microsoft SQL Server\80\Tools\Binn>bcp northwind.dbo.orders out orders.txt -SNJROS1D151\NJROS1D151DEV -Usa -PpwdSQLState = 08001, NativeError = 17 Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.SQLState = 01000, NativeError = 53Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect()).[quote]I'm so confused...at least it's working...But why 1 box and not the other?Brett8-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-30 : 15:08:24
|
| I always use TCP/IP to connect to SQL Server. To answer your question, I don't know. For the bcp error, I would setup an alias maybe named NJROS1D151DEV that uses NJROS1D151, <portNumberOfAlias>.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-30 : 15:19:00
|
| Yup that's what I did...I gotta read up on the difference between named pipes and ip...And why my coworker behind ne doesn't have this problem...The only difference is the sybase install and (I believe) a hot fix push....Thanks Tara...Brett8-) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-30 : 15:37:57
|
| When it all starts to go a bit pear-shaped, like you describe, I have a go with ODBCPING to narrow down some of the options. A bit. Maybe ...P.S. Not sure that hs shipped since SQL7 versions of toolsKristen |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-30 : 15:50:43
|
quote:
Originally posted by Kristen
When it all starts to go a bit pear-shaped, like you describe, I have a go with ODBCPING to narrow down some of the options. A bit. Maybe ...P.S. Not sure that hs shipped since SQL7 versions of toolsKristen
A little hint would be cool...or I could go google....Brett8-) |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-30 : 16:05:15
|
| OK, Googled...Looks worth a try..says it ships with everything higher than 6.5...can't find it....dowload somewhere?Brett8-) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-30 : 16:23:50
|
| ODBCPING used to come with SQL (SQL-7). It basically asks for the Server Name, UserID/Password and attempts to see if it can find the server. The connection has somewhat less baggage than a full-blown EM/QA connection, so IME can help to narrow-down connection problems.I've Emailed you a link.Kristen |
|
|
|
|
Server Registration Fails