re-install SQL Server 2000 SP3

Hi,

I 've re-installSQL Server 2000 SP3 just to change password

And while installation I got an error that the instillation fails the message as the following:
" setup Failed to configure the server, refer to the server error logs and setup error logs for more information. "

Any idea,

What do the error logs say?
sql

Registration of CLR-function sample fails

HI

I'm trying to reproduce the VB CLR sample concat function from the SQL documentation (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/denet9/html/5a188b50-7170-4069-acad-5de5c915f65d.htm)

I've installed Visual Studio 2005 and compiled the DLL which seems to work fine, but when I try to register the DLL with this call:

create assembly sqlfuncdll from 'D:\SQLdata\dll\SQLfunctions.dll'

I got this error:

Msg 10301, Level 16, State 1, Line 1

Assembly 'SQLfunctions' references assembly 'system.windows.forms, version=2.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request.

When I remove the system.windows.form reference from the VB project (my suggestion is : I don't need the forms) then the project won't builld, so somehow it needs it.

What sould I do to get this DLL working?

hans

What type of Visual Studio project are you using? If you make a class library rather than a Windows Forms application then just the code in the documentation alone should compile fine without the reference.

--Bonnie

|||

The application type of the project is indeed "Class Library".

When I remove the System.Windows.Forms reference from the project, then the compilation of the DLL fails, I don't get any error message why, it just don't work. When I put the reference back, then the compilation is succesfull. I can't get why it needs this reference.

Some how I should get this project working without the System.Windows.Forms reference, because in the SQL documentation I found that this library is not supported and not linked by default :

http://msdn2.microsoft.com/en-us/library/ms403279.aspx

I started the VB project from scratch and now it does not need the System.Windows.Forms reference I don't understand why, but some how this reference was needed.

|||Most people make the mistake that they want to use MessageBox.Show in their Assemblies, which is sure not supported by the SQL CLR. If you are not sure which command is preventing you from registering the assembly, send the code over and we / I will have a look on it.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Registration Fails

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?...are you registering by IP or DNS name? I know that when i've had problems between here and the great state of Maine I had to reregister using the servers IP.|||can you ping its ip? what does a trace do?|||DNS and I can ping it....|||are you able to ping it both by IP and DNS? (if you can't by DNS ya might try and register it by it's IP)...|||Just tried..I can ping by both...I'm gonna go over and bother the other guy who's connecting to see what's different...|||OK, it was suggested that I try an osql connection from dos...

fact is I already tried that...

BUT it is a great point...for some reason the error message are more helpful..it's like QA interferes with the message...

Then I said, what about bcp...and I got a message I never saw before

C:\>bcp northwind.dbo.orders out orders.txt -SNJROS1D15\NJROS1D151DEV -Usa -Ppwd

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.

C:\>


I'm going to try bcp from another box from xp_cmdshell|||Have you installed a Sybase client recently?|||I have a Sybase client AND server running and have no prob.

Brett, did your nw guys push something on the client as well? Try odbcping (of course it'll fail, but try with different security switches) Also, did you happen to do anything in terms of aliasing experimentation? Or maybe in Server Network Configuration on the offending server (sounds like it's offending your intelligence, doesn't it?;)|||The few times I have seen BCP fail with a ct_connect error, it was a Sybase bcp attempting to talk to a MS SQL Server. The problem I always have is that Sybase adds itself to the beginning of the PATH environment variable, so you tend to get it first. I have no doubt you can force the two to get along. Probably only take a couple rolls of duct tape. Here is the error I get for trying to connect to no server:

bcp pubs..authors out auth.txt /Sgarbage /T

SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
SQLState = 01000, NativeError = 53
Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).|||Another possiblity would be hav eyou gotten a beta version of Windows XP SP2? Rumour has it that this will come with a built-in firewall that will block port 1433 by default.

http://www.microsoft.com/sql/techinfo/administration/2000/security/winxpsp2faq.asp

I think we will all be having to play around with this, before our desktop groups get the idea into their heads that they need to deploy this service pack overnight.|||Yup, you're right, I forgot about common utility names. And CTLIB is very suspicious in the content of your error...aka CTlib API, which is Sybase's new web.sql API. Are you screwing with Sybase, Brett?|||Yup installed sysbase months agao...

I like the combiniation of errors thing...yes I think our server ops pushed something last week...

Got the Alias thing to work with the ip address...

What bugs me is that my other NJ is ok..probably on an isolated domain, as well as PA and Ireland...but that doesn't explain PROD on the same network...|||Are you screwing with Sybase, Brett?

Hey, I bought her a drink...

sybase, oracle, db2, sql server....all the same...just a different dress...

Was looking at mySQL...now that's a wolfer...kinda like acess...and now that I say that is access an rdbms? It's definetley not client server...how about foxpro DBaseIII...man they're just to many of them...

which platform would you like to choose?

It's this gdamn network crap I hate...

EDIT: Does Mac have an RDBMS? :eek:|||I have had intermittent problems with Enterprise Mangler where the connection would timeout under TCP/IP, but would be fine under Named Pipes. I never found a rhyme or reason to it. See what happens when you change your default net library in the Client Network Utility. Pretty much reduced to groping at, er...grasping at straws here.|||EDIT: Does Mac have an RDBMS? :eek:

As a matter of fact...sort of. There is a product called 4th Dimension that is an Access-like application. I am not certain if there are any Mac servers to start with. There very well could be, though.|||My original protocal order was Pipes then TCP/IP...when I switched (to enable the alias so I could get some work done), and then tried the bcp in dos, I then get the standard not found. not authed bullshit message...|||As a matter of fact...sort of. There is a product called 4th Dimension that is an Access-like application. I am not certain if there are any Mac servers to start with. There very well could be, though.
Yes there are, they are referred to as Linux boxes ;)|||Anyone know where ODBCPING is located?

M$ says it ships with 6.5 and higher...can't find it...|||It's on the CD, you need to copy it from there into your BINN directory. Or, as an alternative, I can put it here, let me know.|||Thanks...all of the stuff is on a lan share..have to look...

That said...are you telling me it's not part of the install? I select everything...and then why isn't it available as a download from M$?