Del, I have attached the SQL results. It is odd becuase it comes back as a Null. I went in to sp_adservername and it was already there. So I sp_dropserver and re sp_addservername and it still comes back Null. Aaron
CODE: sp_dropserver 'FBINET' GO sp_addserver 'FBINET' GO select @@servername GO RESULTS: (1 row(s) affected) Remote logins for remote server 'FBINET' have been dropped. (1 row(s) affected) Server dropped. (1 row(s) affected) (1 row(s) affected) Server added. (1 row(s) affected) (1 row(s) affected) Aaron -----Original Message----- From: Del Hoobler [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 11:02 AM To: [EMAIL PROTECTED] Subject: Re: HELP with SQL TDP > When I install the TDP for SQL on Windows 2000 server SP2, It starts to > open, then it closes right afterwards. Does anyone have any ideas? I am not > having this problem on my other win2k server Aaron, Try issuing this command from SQL Analyzer: select @@servername Does it return NULL? If so, you need to set the SQL Server name using the sp_addserver stored procedure. We have seen a few customer's SQL servers that have had their SQL Server name set to NULL (some third party products have been to blame). Let me know what happens. Thanks, Del ---------------------------------------------------- Del Hoobler IBM Corporation [EMAIL PROTECTED] - Leave everything a little better than you found it. - Smile a lot: it costs nothing and is beyond price.
