Can't get connected to MSDE Remotely

I have a problem getting connected to an instance of MSDE remotely. I can
register the instance in Enterprise Manager, and work with it locally on the
machine it is installed on but cannot get connected remotely. I get the
famous SQL Server does not exist or access is denied.
It is a named instance.
The security mode is set to SQL.
Network Protocols are enabled.
netstat tells me that it is listening on the correct port.
I'm logging in remotely as sa with the correct password.
Any help here would be appreciated.
Also for some reason the name of the server doesn't show up in the list in
Enterprise manager on the remote machine when trying to register the server.
I typed in the name of the server, the sa login and password, but still the
same error. Server doesn't exist or access is denied.
"jdehne" wrote:

> I have a problem getting connected to an instance of MSDE remotely. I can
> register the instance in Enterprise Manager, and work with it locally on the
> machine it is installed on but cannot get connected remotely. I get the
> famous SQL Server does not exist or access is denied.
> It is a named instance.
> The security mode is set to SQL.
> Network Protocols are enabled.
> netstat tells me that it is listening on the correct port.
> I'm logging in remotely as sa with the correct password.
> Any help here would be appreciated.
|||I have also tried adding the alias with the same port as MSDE is configured.
"jdehne" wrote:
[vbcol=seagreen]
> Also for some reason the name of the server doesn't show up in the list in
> Enterprise manager on the remote machine when trying to register the server.
> I typed in the name of the server, the sa login and password, but still the
> same error. Server doesn't exist or access is denied.
> "jdehne" wrote:
|||i have also noticed that when running osql -L on the remote machine the MSDE
instance does not show up.
"jdehne" wrote:
[vbcol=seagreen]
> I have also tried adding the alias with the same port as MSDE is configured.
> "jdehne" wrote:
|||Am Mon, 17 Oct 2005 15:06:03 -0700 schrieb jdehne:
[vbcol=seagreen]
> i have also noticed that when running osql -L on the remote machine the MSDE
> instance does not show up.
> "jdehne" wrote:
I can only guess:
a) TCP is enabled on the server but not on the client
b) connect doesn't work with servername but with server-IP
c) MDAC's are different versions
bye,
Helmut
|||hi,
jdehne wrote:
> i have also noticed that when running osql -L on the remote machine
> the MSDE instance does not show up.
try having a look at http://support.microsoft.com/kb/841251/en-us ,
http://support.microsoft.com/kb/841249/en-us
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I managed to figure it out. SP2 Secruity center was blocking the port and I
had add the sqlserver.exe to the list of programs that can get through the
firewall.
"Andrea Montanari" wrote:

> hi,
> jdehne wrote:
> try having a look at http://support.microsoft.com/kb/841251/en-us ,
> http://support.microsoft.com/kb/841249/en-us
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>

Can't Find SQL Native Client in ODBC Connection Manager in SQL Server Open Database Connectivit

I apologize if this is not the correct forum for this posting. Looking at the descriptions, it appeared to be the best choice.

I am running Windows XP Pro SP2. I have installed the SQL Native Client for

XP. However, when I try to add a new data source through ODBC Connection

Manager, SQL Native Client is not listed as an option. I have followed this procedure on three other systems with no problems. What would be causing the

SQL Native Client to not show up in the list of available ODBC data sources?

Hi, James,

First of all - are you sure that the installation of the SQL Native Client completed successfully? Do you see the packet in the Add/Remove Programs applet? What you can try first is to uninstall (if available) and reinstall the Client, check if any errors or warnings would be reported.

Going further - the ODBC drivers information is stored in the registry. Using regedit, go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI and check if the SQL Native Client driver is present, the entries in the folder as well as an entry at "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers" folder.

If the SQL Native Client driver is not present in the registry, you might have a permission issue. One possible approach is to run and capture a RegMon log during the installation (http://www.microsoft.com/technet/sysinternals/SystemInformation/Regmon.mspx) and see if access to the key above failed.

If the SQL Native Client driver is present in the registry, then for some reason the ODBC Administrator fails to enumerate it or it contains invalid entries. First step would be to compare the entries to a "working" machine and then you could probably use RegMon again - this time when running ODBC Administrator.

Based on the findings, you could take corrective actions and start seeing the driver properly.

HTH,

Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thanks for the reply. SQL Native Client does appear in Add/Remove programs, and I am able to uninstall and reinstall. I will do the other checks you mentioned, and let you know the results. Thanks.|||

I am having a very similar problem. I am using Visual C++ 2005 Express and have installed the Microsoft SQL Server Native Client. All the mentioned registrty entries appear to be correct. I have also include all of the ODBC components in my toolbox. When I try to configure the ODBC data adpater, create a new connection, the only types of data sources that are in the possible list are the SQL Server and Access. If I add an OdbcConnection tool to the form and try to modify the connection string to a new connection, I get a message that the data provider identified by guid "all zeroes" could not be loaded. It would appear that csomething is missing.

I have tried to find a "Data" component to reference in the project that might include the missing component, but have had no success.

Can't Find SQL Native Client in ODBC Connection Manager in SQL Server Open Database Connectivit

I apologize if this is not the correct forum for this posting. Looking at the descriptions, it appeared to be the best choice.

I am running Windows XP Pro SP2. I have installed the SQL Native Client for XP. However, when I try to add a new data source through ODBC Connection Manager, SQL Native Client is not listed as an option. I have followed this procedure on three other systems with no problems. What would be causing the SQL Native Client to not show up in the list of available ODBC data sources?

Hi, James,

First of all - are you sure that the installation of the SQL Native Client completed successfully? Do you see the packet in the Add/Remove Programs applet? What you can try first is to uninstall (if available) and reinstall the Client, check if any errors or warnings would be reported.

Going further - the ODBC drivers information is stored in the registry. Using regedit, go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI and check if the SQL Native Client driver is present, the entries in the folder as well as an entry at "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers" folder.

If the SQL Native Client driver is not present in the registry, you might have a permission issue. One possible approach is to run and capture a RegMon log during the installation (http://www.microsoft.com/technet/sysinternals/SystemInformation/Regmon.mspx) and see if access to the key above failed.

If the SQL Native Client driver is present in the registry, then for some reason the ODBC Administrator fails to enumerate it or it contains invalid entries. First step would be to compare the entries to a "working" machine and then you could probably use RegMon again - this time when running ODBC Administrator.

Based on the findings, you could take corrective actions and start seeing the driver properly.

HTH,

Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thanks for the reply. SQL Native Client does appear in Add/Remove programs, and I am able to uninstall and reinstall. I will do the other checks you mentioned, and let you know the results. Thanks.
|||

I am having a very similar problem. I am using Visual C++ 2005 Express and have installed the Microsoft SQL Server Native Client. All the mentioned registrty entries appear to be correct. I have also include all of the ODBC components in my toolbox. When I try to configure the ODBC data adpater, create a new connection, the only types of data sources that are in the possible list are the SQL Server and Access. If I add an OdbcConnection tool to the form and try to modify the connection string to a new connection, I get a message that the data provider identified by guid "all zeroes" could not be loaded. It would appear that csomething is missing.

I have tried to find a "Data" component to reference in the project that might include the missing component, but have had no success.

sql

Can't Find SQL Native Client in ODBC Connection Manager

I am running Windows XP Pro SP2. I have installed the SQL Native Client for
XP. However, when I try to add a new data source through ODBC Connection
Manager, SQL Native Client is not listed as an option. I have followed this
procedure on three other systems with no problems. What would be causing the
SQL Native Client to not show up in the list of available ODBC data sources?MDAC issues, related DLL conflicts. The ODBC Data Source
Administrator piece can get hosed out with DLL conflicts on
an MDAC installation. You'd probably want to start checking
the MDAC installation using component checker. You can
download it from:
http://msdn2.microsoft.com/en-us/data/aa937730.aspx
-Sue
On Tue, 13 Feb 2007 10:31:01 -0800, Jim Strickland <Jim
Strickland@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I am running Windows XP Pro SP2. I have installed the SQL Native Client for
>XP. However, when I try to add a new data source through ODBC Connection
>Manager, SQL Native Client is not listed as an option. I have followed this
>procedure on three other systems with no problems. What would be causing th
e
>SQL Native Client to not show up in the list of available ODBC data sources?[/vbcol
]

Can't Find SQL Native Client in ODBC Connection Manager

I am running Windows XP Pro SP2. I have installed the SQL Native Client for
XP. However, when I try to add a new data source through ODBC Connection
Manager, SQL Native Client is not listed as an option. I have followed this
procedure on three other systems with no problems. What would be causing the
SQL Native Client to not show up in the list of available ODBC data sources?
MDAC issues, related DLL conflicts. The ODBC Data Source
Administrator piece can get hosed out with DLL conflicts on
an MDAC installation. You'd probably want to start checking
the MDAC installation using component checker. You can
download it from:
http://msdn2.microsoft.com/en-us/data/aa937730.aspx
-Sue
On Tue, 13 Feb 2007 10:31:01 -0800, Jim Strickland <Jim
Strickland@.discussions.microsoft.com> wrote:

>I am running Windows XP Pro SP2. I have installed the SQL Native Client for
>XP. However, when I try to add a new data source through ODBC Connection
>Manager, SQL Native Client is not listed as an option. I have followed this
>procedure on three other systems with no problems. What would be causing the
>SQL Native Client to not show up in the list of available ODBC data sources?

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

can't find Enterprise Manager and Query Analyzer after setup

I downloaded the trial version of sql server 2005. but after installation, I couldnt find the Enterprise Manager and Query Analyzer. Any idea about that? Thanks.

Hi zhishan,

I believe those services can be configured from control panel (turn windows features on or off). Check the boxes next to enterprise manager services and query analyzer, then ok, and windows wil configure and update for those services.

|||Thanks djartsinc - do you know where on the control panel has the function? I spent a long time trying to find, but couldn't...|||

Which Edition of SQL Server 2005 do you download? If it is SQL Server 2005 Express, such tool is not included. Please try SQL Server 2005 Expree with Advanced Services, which includes tools. You can get it from the same download website as SQL Server 2005 Express.

Can't export to PDF with hidden group

I have a report that uses a matrix control to display the data. After
spending hours on the report getting it to look right in Report Manager, I
went to export to PDF and could not. I got the error "Internet Explorer
cannot download format=PDF".
So I proceeded to recreate the report step by step. At each step, I
deployed, ran, and try to export to pdf.
The problem comes when I have a group make the visible property=false.
My work around is to change the Font color to white and disable growing.
Is this a known issue and is being worked on or should I report this to MS?Please email me a copy of your .rdl and .rdl.data file so I can take a look.
Also, please send me a copy of the error you're seeing in the latest log
file in your /ReportServer/LogFiles directory.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"David" <David@.discussions.microsoft.com> wrote in message
news:AC2E1B8D-CB2F-4AF5-BEF9-F72A470BC626@.microsoft.com...
>I have a report that uses a matrix control to display the data. After
> spending hours on the report getting it to look right in Report Manager, I
> went to export to PDF and could not. I got the error "Internet Explorer
> cannot download format=PDF".
> So I proceeded to recreate the report step by step. At each step, I
> deployed, ran, and try to export to pdf.
> The problem comes when I have a group make the visible property=false.
> My work around is to change the Font color to white and disable growing.
> Is this a known issue and is being worked on or should I report this to
> MS?|||I would but I need your email. You can send it to:
david_perkins a t concentra d o t com
"Donovan Smith [MSFT]" wrote:
> Please email me a copy of your .rdl and .rdl.data file so I can take a look.
> Also, please send me a copy of the error you're seeing in the latest log
> file in your /ReportServer/LogFiles directory.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:AC2E1B8D-CB2F-4AF5-BEF9-F72A470BC626@.microsoft.com...
> >I have a report that uses a matrix control to display the data. After
> > spending hours on the report getting it to look right in Report Manager, I
> > went to export to PDF and could not. I got the error "Internet Explorer
> > cannot download format=PDF".
> >
> > So I proceeded to recreate the report step by step. At each step, I
> > deployed, ran, and try to export to pdf.
> >
> > The problem comes when I have a group make the visible property=false.
> >
> > My work around is to change the Font color to white and disable growing.
> >
> > Is this a known issue and is being worked on or should I report this to
> > MS?
>
>|||David sent me a copy of his report and I'm investigating. A second repro
certainly wouldn't hurt anything so please email me a copy of your .rdl and
.rdl.data file so I can take a look.
Thanks.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Goncalo" <Goncalo@.discussions.microsoft.com> wrote in message
news:87CB2105-49AB-440C-9DA9-7415FCE8BD55@.microsoft.com...
> I'm having the same problem. Is there any solution to this?
> Goncalo
>
> "Donovan Smith [MSFT]" wrote:
>> Please email me a copy of your .rdl and .rdl.data file so I can take a
>> look.
>> Also, please send me a copy of the error you're seeing in the latest log
>> file in your /ReportServer/LogFiles directory.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "David" <David@.discussions.microsoft.com> wrote in message
>> news:AC2E1B8D-CB2F-4AF5-BEF9-F72A470BC626@.microsoft.com...
>> >I have a report that uses a matrix control to display the data. After
>> > spending hours on the report getting it to look right in Report
>> > Manager, I
>> > went to export to PDF and could not. I got the error "Internet Explorer
>> > cannot download format=PDF".
>> >
>> > So I proceeded to recreate the report step by step. At each step, I
>> > deployed, ran, and try to export to pdf.
>> >
>> > The problem comes when I have a group make the visible property=false.
>> >
>> > My work around is to change the Font color to white and disable
>> > growing.
>> >
>> > Is this a known issue and is being worked on or should I report this to
>> > MS?
>>

Cant enter report manager with forms security

I implemented the sample from microsoft, but i dont know what went wrong i
can access the server but cant enter the report manager, im redirected to
the folder.aspx page but then I get back to UILogon.aspx, could it be that
when i installed RS i ddint check the SSL checkbox, or some other config
problem?Or, perhaps you access the Report Manager by using localhost instead of the
computer name?
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Rodrigo Sánchez" <rodrigoss@.netshoreprogramming.com> wrote in message
news:OobjdyhkEHA.3556@.TK2MSFTNGP12.phx.gbl...
> I implemented the sample from microsoft, but i dont know what went wrong i
> can access the server but cant enter the report manager, im redirected to
> the folder.aspx page but then I get back to UILogon.aspx, could it be that
> when i installed RS i ddint check the SSL checkbox, or some other config
> problem?
>|||Hi all,
I have been trying ti use the Sample Forms Authentication since morning but
can not make it work still. I followed the steps and could register a user
"administrator" from LOgon.aspx page. I see this user getting created in the
Users table of UserAccounts database. I also add the sample code for username
to RSReportServer.config file as given in the sample description. Now I try
to login using the username and password but brings me back to the Logon.aspx
page. Anybody please help.
PS:- I can also see this user from ReportServer but cannot enter
ReportManager)
Thanks in advance.
Pinal.
"Teo Lachev" wrote:
> Or, perhaps you access the Report Manager by using localhost instead of the
> computer name?
> --
> Hope this helps.
> ----
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ----
> "Rodrigo Sánchez" <rodrigoss@.netshoreprogramming.com> wrote in message
> news:OobjdyhkEHA.3556@.TK2MSFTNGP12.phx.gbl...
> > I implemented the sample from microsoft, but i dont know what went wrong i
> > can access the server but cant enter the report manager, im redirected to
> > the folder.aspx page but then I get back to UILogon.aspx, could it be that
> > when i installed RS i ddint check the SSL checkbox, or some other config
> > problem?
> >
> >
>
>sql

Cant enable database for full-text searching

When trying to create a new full-text catalogue for a database through enterprise manager the following error is generated:

The Microsoft Search service cannot be administered under the present user account

When attempting to enable a database for full-text searching by running the stored procedure "sp_fulltext_database" the following error message is recieved:

Server: Msg 7635, Level 16, State 1, Procedure sp_fulltext_database, Line 46
The Microsoft Search service cannot be administered under the present user account

The user account that the SQL service is running under has full administrative rights (including the privileges such as log on locally/as a batch/as a service etc - the SQL BUILTIN\Adminstrators login also exists) and the MSSQL and MS Search services have been stopped and started to ensure that the system account does have control of the MS Search service.

Although the text of the error message refers to user rights, line 46 of the stored procedure refers to the DBCC CALLFULLTEXT function and so it appears that the process is actually falling over when trying to drop catalogues.

The server was upgraded from SQL Server 6.5 to SQL Server 2000 and the Full-Text Search component was selected. However it was noticed that the folders Config, Projects and GatherLogs were not present under the following directory:

C:\Program files\Microsoft SQL Server\MSSQL\FTData\SQL Server\

(It was attempted to reinstall the Full-Text Search component from the SQL 2000 CD but as the component was already installed this wasnt possible)

The relevant config files, including the schema.txt, were then copied to the above location and it was ensured that the schema.txt file was the same in both the above location and the MSSQL\Binn folder (and on the SQL 2000 CD). But this has had no effect.

It has also been noticed that there is no registry key relating to:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\SQLFTSearch\Setup\Schema

However we have another server (which was a SQL 2000 install, as opposed to an upgrade) which also doesnt have this registry entry and that server isnt experiencing any problems with full-text search/indexing.

Can anyone suggest any other possible fixes before we resort to reinstalling SQL server?

Thanks,
ElaineHave you tried to run the stored procedure or sp_fulltext_database using query analyzer ?|||I'd be looking at the following closely ( assuming you may not have checked these out already ):

www.microsoft.com/technet

www.sqlmag.com

I'd be checking technet first as it sounds awfully like a upgrade "undocumented" type problem.

Apart from that, sounds like you have done everyting else right.

Try setting the SQL Server account to run under a domain account, but make sure you set the startup account to be the same in the Server Properties tab in EM as the account you use when you alter the startup account in Services. This is for the benefit of the Full Text service.

Post back if probs.

J.|||Thanks for your suggestions

...but we resorted to reinstalling SQL which has worked, so it appears that there might be problems with the full-text feature if you've upgraded to sql 2000 from 6.5 (as opposed to a straight 2000 install).

(we retained the databases by detaching them and copying the .mdf/.ldf files to another location. Then once the new install of SQL 2000 was complete we re-attached the databases - NB. the detach/attach method doesn't cover DTS packages. Also if specific users are created for a DB after reattaching you might need to delete them from the DB user section, then recreate them in the security logins section)

Can't email reports

Hello
I'm trying to send the reports in Report Manager by mail, but I have always
the same message -> "Error sending email.
System.Runtime.InteropServices.COMException (0x80040211): The message could
not be sent to the SMTP server. The transport error code was 0x800ccc15. The
server response was not available."
I have installed W XP SP2, and have no firewall
When I installed Rep. Serv. I specified a valid smtp adress.
Can everyone help me pleaseSorry Bruno; it appears you have not included enough information in your
question. How are you trying to send the e-mail? Are you using the
subscription feature in Reporting Services? If so, take a look at the file
RSReportServer.config which is in the ReportServer subfolder of your
Reporting Services installation folder (this in turn is located in the folder
where your SQL Server instance is installed). In this file, there is an XML
element called RSEmailDPConfiguration. Within this element there is a
subelement called SMTPServer. This is where your SMTP server is configured.
Is this configured correctly, i.e. is it pointing to a valid SMTP server like
an Exchange Server?
I am assuming you are trying to send the report using the subscription
feature.
Charles Kangai, MCT, MCDBA
"Bruno" wrote:
> Hello
> I'm trying to send the reports in Report Manager by mail, but I have always
> the same message -> "Error sending email.
> System.Runtime.InteropServices.COMException (0x80040211): The message could
> not be sent to the SMTP server. The transport error code was 0x800ccc15. The
> server response was not available."
> I have installed W XP SP2, and have no firewall
> When I installed Rep. Serv. I specified a valid smtp adress.
>
> Can everyone help me please|||Hello Charles and thanks to help me
Yes, I am using the subcription feature to send email in report manager site.
I follow the suggestion do check the RSReportServer.config and everything is
ok as you can see above:
<RSEmailDPConfiguration>
<SMTPServer>10.250.1.123</SMTPServer> <SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>reports@.abcorp.com</From>
..................
The smtp adress is valid, because is from the exchange server.
All the sql server services and report services are starting with a domain
account and the sql server uses the mix mode autentication.
When I installed the rep server I selected the sql autentication (sa user)
in credentials to connect to sql server.
When I depoy the reports to Report manager, I can see them perfectly, but
can't send them by mail. The error is always the same "Error sending email.
System.Runtime.InteropServices.COMException (0x80040211): The message could
not be sent to the SMTP server. The transport error code was 0x800ccc15. The
server response was not available"
Can SP2(WinXP) the problem?
Thank you for the help!!!
"Charles Kangai" wrote:
> Sorry Bruno; it appears you have not included enough information in your
> question. How are you trying to send the e-mail? Are you using the
> subscription feature in Reporting Services? If so, take a look at the file
> RSReportServer.config which is in the ReportServer subfolder of your
> Reporting Services installation folder (this in turn is located in the folder
> where your SQL Server instance is installed). In this file, there is an XML
> element called RSEmailDPConfiguration. Within this element there is a
> subelement called SMTPServer. This is where your SMTP server is configured.
> Is this configured correctly, i.e. is it pointing to a valid SMTP server like
> an Exchange Server?
> I am assuming you are trying to send the report using the subscription
> feature.
> Charles Kangai, MCT, MCDBA
> "Bruno" wrote:
> > Hello
> >
> > I'm trying to send the reports in Report Manager by mail, but I have always
> > the same message -> "Error sending email.
> > System.Runtime.InteropServices.COMException (0x80040211): The message could
> > not be sent to the SMTP server. The transport error code was 0x800ccc15. The
> > server response was not available."
> >
> > I have installed W XP SP2, and have no firewall
> > When I installed Rep. Serv. I specified a valid smtp adress.
> >
> >
> > Can everyone help me please|||The problem was in Anti-Virus (McAfee 8 Ent)
"Bruno" wrote:
> Hello
> I'm trying to send the reports in Report Manager by mail, but I have always
> the same message -> "Error sending email.
> System.Runtime.InteropServices.COMException (0x80040211): The message could
> not be sent to the SMTP server. The transport error code was 0x800ccc15. The
> server response was not available."
> I have installed W XP SP2, and have no firewall
> When I installed Rep. Serv. I specified a valid smtp adress.
>
> Can everyone help me please

Can't disable publishing

SQL Server will not allow me to disable publishing; it just gets hung up and freezes. I have tried using the wizard in Enterprise Manager and I have also tried running sp_dropsubscription and sp_droppublication in Query Analyzer. I found Hilary's past p
ost on a similar problem that says to run the following code (below). What does this code do? I was wondering if it would help my problem. Or what if I just changed replInfo = 0? I just want to disable the publication. Thank you.
CREATE TABLE [MSdistributiondbs] (
[name] [sysname] NOT NULL ,
[min_distretention] [int] NOT NULL ,
[max_distretention] [int] NOT NULL ,
[history_retention] [int] NOT NULL
) ON [PRIMARY]
GO
this code was specific to someone who was disabling publishing on a database
which had been restored from another server where it was being published.
When you restore a published database from another server, some replication
objects are not restored and others are.
In this case this table was not restored and to disable publishing you need
to create it.
You are experienceing locking which indicates other factors at work. Try to
disable it again and wait till you get a response.
If you don't stop SQL Server agent and try again, or make sure all log
reader, distribution agents, and merge agents using this database are
stopped.
"Andrea Worley" <k_Rage@.hotmail.com> wrote in message
news:5180D4E7-0CE9-4B44-BE56-5CE5B82129A1@.microsoft.com...
> SQL Server will not allow me to disable publishing; it just gets hung up
and freezes. I have tried using the wizard in Enterprise Manager and I have
also tried running sp_dropsubscription and sp_droppublication in Query
Analyzer. I found Hilary's past post on a similar problem that says to run
the following code (below). What does this code do? I was wondering if it
would help my problem. Or what if I just changed replInfo = 0? I just want
to disable the publication. Thank you.
> CREATE TABLE [MSdistributiondbs] (
> [name] [sysname] NOT NULL ,
> [min_distretention] [int] NOT NULL ,
> [max_distretention] [int] NOT NULL ,
> [history_retention] [int] NOT NULL
> ) ON [PRIMARY]
> GO
>
|||I stopped the Log Reader agent and tried to drop the publication again, and it worked. Thank you so much.
-- Hilary Cotter wrote: --
this code was specific to someone who was disabling publishing on a database
which had been restored from another server where it was being published.
When you restore a published database from another server, some replication
objects are not restored and others are.
In this case this table was not restored and to disable publishing you need
to create it.
You are experienceing locking which indicates other factors at work. Try to
disable it again and wait till you get a response.
If you don't stop SQL Server agent and try again, or make sure all log
reader, distribution agents, and merge agents using this database are
stopped.
"Andrea Worley" <k_Rage@.hotmail.com> wrote in message
news:5180D4E7-0CE9-4B44-BE56-5CE5B82129A1@.microsoft.com...
> SQL Server will not allow me to disable publishing; it just gets hung up
and freezes. I have tried using the wizard in Enterprise Manager and I have
also tried running sp_dropsubscription and sp_droppublication in Query
Analyzer. I found Hilary's past post on a similar problem that says to run
the following code (below). What does this code do? I was wondering if it
would help my problem. Or what if I just changed replInfo = 0? I just want
to disable the publication. Thank you.
> [name] [sysname] NOT NULL ,
> [min_distretention] [int] NOT NULL ,
> [max_distretention] [int] NOT NULL ,
> [history_retention] [int] NOT NULL
> ) ON [PRIMARY]
> GO
>

Cant delete user table

I have 4 user tables that show up in Enterprise Manager as SYSTEM tables.
The type and xtype in sysobjects are both U. They show up in object browser
under user tables. When I try to delete them I get the following message:
You tried to delete one or more system objects. They were not deleted.
Anyone have any ideas as to what is going on here and how I can delete these?
Can you mention the name of these tables?
Thanks
GYK
"Lyle" wrote:

> I have 4 user tables that show up in Enterprise Manager as SYSTEM tables.
> The type and xtype in sysobjects are both U. They show up in object browser
> under user tables. When I try to delete them I get the following message:
> You tried to delete one or more system objects. They were not deleted.
> Anyone have any ideas as to what is going on here and how I can delete these?
|||Yes, the table names are:
conflict_pubInvHist_Head_Det_Invoice_History_Detai l
conflict_pubInvHist_Head_Det_Invoice_History_Heade r
conflict_PubInvoice_Head_Det_Invoice_History_Detai l
conflict_PubInvoice_Head_Det_Invoice_History_Heade r
Lyle
"GYK" wrote:
[vbcol=seagreen]
> Can you mention the name of these tables?
> Thanks
> GYK
> "Lyle" wrote:
|||Yes, the table names are:
conflict_pubInvHist_Head_Det_Invoice_History_Detai l
conflict_pubInvHist_Head_Det_Invoice_History_Heade r
conflict_PubInvoice_Head_Det_Invoice_History_Detai l
conflict_PubInvoice_Head_Det_Invoice_History_Heade r
Lyle
"GYK" wrote:
[vbcol=seagreen]
> Can you mention the name of these tables?
> Thanks
> GYK
> "Lyle" wrote:
|||Yes, the table names are:
conflict_pubInvHist_Head_Det_Invoice_History_Detai l
conflict_pubInvHist_Head_Det_Invoice_History_Heade r
conflict_PubInvoice_Head_Det_Invoice_History_Detai l
conflict_PubInvoice_Head_Det_Invoice_History_Heade r
Lyle
"GYK" wrote:
[vbcol=seagreen]
> Can you mention the name of these tables?
> Thanks
> GYK
> "Lyle" wrote:

Cant delete user table

I have 4 user tables that show up in Enterprise Manager as SYSTEM tables.
The type and xtype in sysobjects are both U. They show up in object browser
under user tables. When I try to delete them I get the following message:
You tried to delete one or more system objects. They were not deleted.
Anyone have any ideas as to what is going on here and how I can delete these?Can you mention the name of these tables?
Thanks
GYK
"Lyle" wrote:
> I have 4 user tables that show up in Enterprise Manager as SYSTEM tables.
> The type and xtype in sysobjects are both U. They show up in object browser
> under user tables. When I try to delete them I get the following message:
> You tried to delete one or more system objects. They were not deleted.
> Anyone have any ideas as to what is going on here and how I can delete these?|||Yes, the table names are:
conflict_pubInvHist_Head_Det_Invoice_History_Detail
conflict_pubInvHist_Head_Det_Invoice_History_Header
conflict_PubInvoice_Head_Det_Invoice_History_Detail
conflict_PubInvoice_Head_Det_Invoice_History_Header
Lyle
"GYK" wrote:
> Can you mention the name of these tables?
> Thanks
> GYK
> "Lyle" wrote:
> > I have 4 user tables that show up in Enterprise Manager as SYSTEM tables.
> > The type and xtype in sysobjects are both U. They show up in object browser
> > under user tables. When I try to delete them I get the following message:
> >
> > You tried to delete one or more system objects. They were not deleted.
> >
> > Anyone have any ideas as to what is going on here and how I can delete these?|||Yes, the table names are:
conflict_pubInvHist_Head_Det_Invoice_History_Detail
conflict_pubInvHist_Head_Det_Invoice_History_Header
conflict_PubInvoice_Head_Det_Invoice_History_Detail
conflict_PubInvoice_Head_Det_Invoice_History_Header
Lyle
"GYK" wrote:
> Can you mention the name of these tables?
> Thanks
> GYK
> "Lyle" wrote:
> > I have 4 user tables that show up in Enterprise Manager as SYSTEM tables.
> > The type and xtype in sysobjects are both U. They show up in object browser
> > under user tables. When I try to delete them I get the following message:
> >
> > You tried to delete one or more system objects. They were not deleted.
> >
> > Anyone have any ideas as to what is going on here and how I can delete these?|||Yes, the table names are:
conflict_pubInvHist_Head_Det_Invoice_History_Detail
conflict_pubInvHist_Head_Det_Invoice_History_Header
conflict_PubInvoice_Head_Det_Invoice_History_Detail
conflict_PubInvoice_Head_Det_Invoice_History_Header
Lyle
"GYK" wrote:
> Can you mention the name of these tables?
> Thanks
> GYK
> "Lyle" wrote:
> > I have 4 user tables that show up in Enterprise Manager as SYSTEM tables.
> > The type and xtype in sysobjects are both U. They show up in object browser
> > under user tables. When I try to delete them I get the following message:
> >
> > You tried to delete one or more system objects. They were not deleted.
> >
> > Anyone have any ideas as to what is going on here and how I can delete these?

Cant delete user table

I have 4 user tables that show up in Enterprise Manager as SYSTEM tables.
The type and xtype in sysobjects are both U. They show up in object browser
under user tables. When I try to delete them I get the following message:
You tried to delete one or more system objects. They were not deleted.
Anyone have any ideas as to what is going on here and how I can delete these
?Can you mention the name of these tables?
Thanks
GYK
"Lyle" wrote:
[vbcol=seagreen]
> I have 4 user tables that show up in Enterprise Manager as SYSTEM tables.
> The type and xtype in sysobjects are both U. They show up in object brows
er
> under user tables. When I try to delete them I get the following message:
> You tried to delete one or more system objects. They were not deleted.
> Anyone have any ideas as to what is going on here and how I can delete these?[/vbc
ol]|||Yes, the table names are:
conflict_pubInvHist_Head_Det_Invoice_His
tory_Detail
conflict_pubInvHist_Head_Det_Invoice_His
tory_Header
conflict_PubInvoice_Head_Det_Invoice_His
tory_Detail
conflict_PubInvoice_Head_Det_Invoice_His
tory_Header
Lyle
"GYK" wrote:
[vbcol=seagreen]
> Can you mention the name of these tables?
> Thanks
> GYK
> "Lyle" wrote:
>|||Yes, the table names are:
conflict_pubInvHist_Head_Det_Invoice_His
tory_Detail
conflict_pubInvHist_Head_Det_Invoice_His
tory_Header
conflict_PubInvoice_Head_Det_Invoice_His
tory_Detail
conflict_PubInvoice_Head_Det_Invoice_His
tory_Header
Lyle
"GYK" wrote:
[vbcol=seagreen]
> Can you mention the name of these tables?
> Thanks
> GYK
> "Lyle" wrote:
>|||Yes, the table names are:
conflict_pubInvHist_Head_Det_Invoice_His
tory_Detail
conflict_pubInvHist_Head_Det_Invoice_His
tory_Header
conflict_PubInvoice_Head_Det_Invoice_His
tory_Detail
conflict_PubInvoice_Head_Det_Invoice_His
tory_Header
Lyle
"GYK" wrote:
[vbcol=seagreen]
> Can you mention the name of these tables?
> Thanks
> GYK
> "Lyle" wrote:
>

cant delete odbc tracing file..

Hi all
I can not delete the odbc manager tracing file.
Even after disabling tracing (in the odbc manager)
i get a windows massage saing another program is using the odbc tracing
file...
Can i stop the odbc manager service?
What other programs may be using this log?
There is no other runing programm or sql server job.
Please help, this file is growing so fast!
TIA
Rea
Rea,
Refer the below snippet from :
'PRB: ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk Space'
http://support.microsoft.com/?id=268591
<start quote>
To turn off ODBC Tracing and remove the associated file, follow these steps:
1.. To disable ODBC Tracing:
1.. For Microsoft Windows NT 4.0:
a.. On the Start menu, click on Control Panel, and then click on Data
Sources(ODBC).
b.. Click on the Tracing tab, and choose Stop Tracing Now.
2.. For Microsoft Windows 2000:
a.. On the Start menu, click on Control Panel, click on Administrative
Tools, and then click on Data Sources (ODBC).
b.. Click on the Tracing tab, and choose Stop Tracing Now.
2.. Stop all ODBC applications, and stop SQL Server. In some cases it may
be necessary to reboot the server to free up the file so that it can be
deleted.
3.. Delete the ODBC Tracing file, usually called "C:\SQL.LOG."
4.. Restart SQL Server.
<end quote>
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Rea Peleg" <rea_p@.afek.co.il> wrote in message
news:eKbGsGHTEHA.1472@.TK2MSFTNGP09.phx.gbl...
> Hi all
> I can not delete the odbc manager tracing file.
> Even after disabling tracing (in the odbc manager)
> i get a windows massage saing another program is using the odbc tracing
> file...
> Can i stop the odbc manager service?
> What other programs may be using this log?
> There is no other runing programm or sql server job.
> Please help, this file is growing so fast!
> TIA
> Rea
>
|||Thanks alot !
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:uaDVzOHTEHA.1732@.TK2MSFTNGP09.phx.gbl...
> Rea,
> Refer the below snippet from :
> 'PRB: ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk
Space'
> http://support.microsoft.com/?id=268591
> <start quote>
> To turn off ODBC Tracing and remove the associated file, follow these
steps:
> 1.. To disable ODBC Tracing:
> 1.. For Microsoft Windows NT 4.0:
> a.. On the Start menu, click on Control Panel, and then click on
Data
> Sources(ODBC).
> b.. Click on the Tracing tab, and choose Stop Tracing Now.
> 2.. For Microsoft Windows 2000:
> a.. On the Start menu, click on Control Panel, click on
Administrative
> Tools, and then click on Data Sources (ODBC).
> b.. Click on the Tracing tab, and choose Stop Tracing Now.
> 2.. Stop all ODBC applications, and stop SQL Server. In some cases it
may
> be necessary to reboot the server to free up the file so that it can be
> deleted.
> 3.. Delete the ODBC Tracing file, usually called "C:\SQL.LOG."
> 4.. Restart SQL Server.
> <end quote>
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Rea Peleg" <rea_p@.afek.co.il> wrote in message
> news:eKbGsGHTEHA.1472@.TK2MSFTNGP09.phx.gbl...
>

cant delete odbc tracing file..

Hi all
I can not delete the odbc manager tracing file.
Even after disabling tracing (in the odbc manager)
i get a windows massage saing another program is using the odbc tracing
file...
Can i stop the odbc manager service'
What other programs may be using this log?
There is no other runing programm or sql server job.
Please help, this file is growing so fast!
TIA
ReaRea,
Refer the below snippet from :
'PRB: ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk Space'
http://support.microsoft.com/?id=268591
<start quote>
To turn off ODBC Tracing and remove the associated file, follow these steps:
1.. To disable ODBC Tracing:
1.. For Microsoft Windows NT 4.0:
a.. On the Start menu, click on Control Panel, and then click on Data
Sources(ODBC).
b.. Click on the Tracing tab, and choose Stop Tracing Now.
2.. For Microsoft Windows 2000:
a.. On the Start menu, click on Control Panel, click on Administrative
Tools, and then click on Data Sources (ODBC).
b.. Click on the Tracing tab, and choose Stop Tracing Now.
2.. Stop all ODBC applications, and stop SQL Server. In some cases it may
be necessary to reboot the server to free up the file so that it can be
deleted.
3.. Delete the ODBC Tracing file, usually called "C:\SQL.LOG."
4.. Restart SQL Server.
<end quote>
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Rea Peleg" <rea_p@.afek.co.il> wrote in message
news:eKbGsGHTEHA.1472@.TK2MSFTNGP09.phx.gbl...
> Hi all
> I can not delete the odbc manager tracing file.
> Even after disabling tracing (in the odbc manager)
> i get a windows massage saing another program is using the odbc tracing
> file...
> Can i stop the odbc manager service'
> What other programs may be using this log?
> There is no other runing programm or sql server job.
> Please help, this file is growing so fast!
> TIA
> Rea
>|||Thanks alot !
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:uaDVzOHTEHA.1732@.TK2MSFTNGP09.phx.gbl...
> Rea,
> Refer the below snippet from :
> 'PRB: ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk
Space'
> http://support.microsoft.com/?id=268591
> <start quote>
> To turn off ODBC Tracing and remove the associated file, follow these
steps:
> 1.. To disable ODBC Tracing:
> 1.. For Microsoft Windows NT 4.0:
> a.. On the Start menu, click on Control Panel, and then click on
Data
> Sources(ODBC).
> b.. Click on the Tracing tab, and choose Stop Tracing Now.
> 2.. For Microsoft Windows 2000:
> a.. On the Start menu, click on Control Panel, click on
Administrative
> Tools, and then click on Data Sources (ODBC).
> b.. Click on the Tracing tab, and choose Stop Tracing Now.
> 2.. Stop all ODBC applications, and stop SQL Server. In some cases it
may
> be necessary to reboot the server to free up the file so that it can be
> deleted.
> 3.. Delete the ODBC Tracing file, usually called "C:\SQL.LOG."
> 4.. Restart SQL Server.
> <end quote>
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Rea Peleg" <rea_p@.afek.co.il> wrote in message
> news:eKbGsGHTEHA.1472@.TK2MSFTNGP09.phx.gbl...
>

Can't connect via Enterprise Manager

Hi All,
We have a MSDE on a W2K server installed. It is running fine and the
application can access it without a problem. We have another server on that
same subnet that has an SQL 2000 server installed. When trying to connect to
the MSDE via the Enterprise Manager, only the local SQL shows up and we
cannot connect to the MSDE instance.
When we go to the ODBC on the MSDE box we see both SQL - the local and the
remote one. On the ODBC on the other server we only see the local one.
Does anybody have an idea what is going on?
Thanks,
Claus
Hi Claus,
Most likely network protocols not enabled. Run svrnetcn.exe and check which
protocols (eg tcp) are enabled. By default, none are.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:%234wb4E1oEHA.4044@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> We have a MSDE on a W2K server installed. It is running fine and the
> application can access it without a problem. We have another server on
that
> same subnet that has an SQL 2000 server installed. When trying to connect
to
> the MSDE via the Enterprise Manager, only the local SQL shows up and we
> cannot connect to the MSDE instance.
> When we go to the ODBC on the MSDE box we see both SQL - the local and the
> remote one. On the ODBC on the other server we only see the local one.
> Does anybody have an idea what is going on?
> Thanks,
> Claus
>
|||Hi Greg,
Thanks for the answer. I double checked and both protocols (tcp and named
pipe) are enabled.
Claus
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:%23LcQb96oEHA.1160@.tk2msftngp13.phx.gbl...
> Hi Claus,
> Most likely network protocols not enabled. Run svrnetcn.exe and check
which[vbcol=seagreen]
> protocols (eg tcp) are enabled. By default, none are.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:%234wb4E1oEHA.4044@.TK2MSFTNGP10.phx.gbl...
> that
connect[vbcol=seagreen]
> to
the
>
|||Claus,
Have you checked the firewall settings on the second server? If it has
the TCP port used by MSDE blocked you won't be able to connect.
Ron Allen
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:%23WJfzS9oEHA.3460@.tk2msftngp13.phx.gbl...
> Hi Greg,
> Thanks for the answer. I double checked and both protocols (tcp and named
> pipe) are enabled.
> Claus
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:%23LcQb96oEHA.1160@.tk2msftngp13.phx.gbl...
> which
> connect
> the
>
|||Hi Claus,
I might need more inputs to trouble shoot this issue. Before this, you
could try Re- registering the MSDE Server in your Enterprise Manager.
Please use the Register SQL Server Wizard. For the sake of Clarity, I am
outling the steps here.
In the Enterprise Manager, If the MSDE Server is already
Registered, then Select Server, Right Click on the Server and Select Delete
SQL Server Registration.
1. In the Enterprise Manager, Start Register SQL Server Wizard. (Right
Click on SQL Server Group, Select New SQL Server Registration)
2. In the 'Select a SQL Server' page (second page), In the 'Available
Servers' Text box enter the Computer Name on which the MSDE is installed.
(Hope it is a default instance. If it is a Named Instance then enter
Instance Name also eg: Default Instance on Computer Named Test - TEST,
Named Instance 'Test1' on TEST - TEST\Test1 ). Then click 'ADD' button.
Click Next.
3. In the Next Page Select Authentication Mode.
4. In the Next Page Click Next
5. In the Last Page Select Finish.
After few minutes, You would see a screen which should say
'Server Registration completed' Status 'Registered Successfully'.
If this goes through, You would be able to see the MSDE in your Enterprise
manager. In case it fails, Please mail me the exact Error Message that you
would see in the Status column. We would try and troubleshoot it further.
Thanks,
Soma Sekhara Reddy
|||There is no firewall on that server and I'm in the same subnet trying to
connect.
"Ron Allen" <rallen@._nospam_src-us.com> wrote in message
news:eXZzmPJpEHA.1644@.tk2msftngp13.phx.gbl...
> Claus,
> Have you checked the firewall settings on the second server? If it
has[vbcol=seagreen]
> the TCP port used by MSDE blocked you won't be able to connect.
> Ron Allen
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:%23WJfzS9oEHA.3460@.tk2msftngp13.phx.gbl...
named[vbcol=seagreen]
on[vbcol=seagreen]
we[vbcol=seagreen]
and[vbcol=seagreen]
one.
>
|||Thanks for your answer. This is what I have tried several times. The answer
I get back is "SQL server not running or access denied". I'm trying to
connect with SQL authentication (sa and password). I'm sure about the sa and
password because I use it in the local ODBC connection and the test works
fine.
I know I'm missing something really obvious - just can't put my finger on
it.
Claus
"Soma Sekhara Reddy" <somsredd@.microsoft.com> wrote in message
news:nyon0IQpEHA.3212@.cpmsftngxa06.phx.gbl...
> Hi Claus,
> I might need more inputs to trouble shoot this issue. Before this, you
> could try Re- registering the MSDE Server in your Enterprise Manager.
> Please use the Register SQL Server Wizard. For the sake of Clarity, I am
> outling the steps here.
> In the Enterprise Manager, If the MSDE Server is already
> Registered, then Select Server, Right Click on the Server and Select
Delete
> SQL Server Registration.
> 1. In the Enterprise Manager, Start Register SQL Server Wizard. (Right
> Click on SQL Server Group, Select New SQL Server Registration)
> 2. In the 'Select a SQL Server' page (second page), In the 'Available
> Servers' Text box enter the Computer Name on which the MSDE is installed.
> (Hope it is a default instance. If it is a Named Instance then enter
> Instance Name also eg: Default Instance on Computer Named Test - TEST,
> Named Instance 'Test1' on TEST - TEST\Test1 ). Then click 'ADD' button.
> Click Next.
> 3. In the Next Page Select Authentication Mode.
> 4. In the Next Page Click Next
> 5. In the Last Page Select Finish.
> After few minutes, You would see a screen which should
say
> 'Server Registration completed' Status 'Registered Successfully'.
> If this goes through, You would be able to see the MSDE in your Enterprise
> manager. In case it fails, Please mail me the exact Error Message that
you
> would see in the Status column. We would try and troubleshoot it further.
> Thanks,
> Soma Sekhara Reddy
>
|||Hi Claus,
Please use the 'ODBCPING' command line utility to check the connectivity.
The syntax is
odbcping -Sservername -Uusername -Ppassword
This tool is loaded with SQL Server client utilities and would be available
on your system. Please do not leave any space betweeb -S and servername,
-S is caps (case sensitive).
Thanks,
Soma Sekhara Reddy

Can't connect via Enterprise Manager

I had a similar problem that was due to the server not
using the proper TCP/IP port. I am guessing that one of
your servers is using a different port, (or none at all),
so it can't be seen by clients looking for the default
port number 1433, at least that was the problem in my case.
Check your Windows registry settings for the following
entries, (this is the key for a default instance, but
there are similar key paths for multiple instances):
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServ
er\SuperSocketNetLib\Tcp\TcpPort
This value is the port that SQL Server will listen on. In
some cases it does not get set up correctly on the
install. The default is a decimal value of "1433" (if it
was blank then the server was only using shared memory
protocol)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\Su
perSocketNetLib\Tcp\DefaultPort
This value is the port that clients use to communicate
with the server. It normally will also be "1433" (decimal).
If you do change these values you should shut down the
server service first and check the registry again after
the server is running again... I had a heck of a time
getting my server to use port 1433, as it kept switching
to port 2433 after the server started up. (Not sure if
it's necessary, but I also put a "" in the TcpDynamicPorts
variable) to make sure dynamic port assignments is off.
Alternatively, if you do have different port settings and
need to keep them as they are, you can create alias
entries on your clients that will associate the proper
protocols and ports for each server.
HTH,
TK
>--Original Message--
>Hi All,
>We have a MSDE on a W2K server installed. It is running
fine and the
>application can access it without a problem. We have
another server on that
>same subnet that has an SQL 2000 server installed. When
trying to connect to
>the MSDE via the Enterprise Manager, only the local SQL
shows up and we
>cannot connect to the MSDE instance.
>When we go to the ODBC on the MSDE box we see both SQL -
the local and the
>remote one. On the ODBC on the other server we only see
the local one.
>Does anybody have an idea what is going on?
>Thanks,
>Claus
>
>.
>
Thanks for the reply. I finally was able to connect. I still don't have any
idea what the reason was. I rebooted both servers and it worked without
making any changes. No entries in the event logs.
MS never stops surprising me.
thanks again to all of you for your good advise,
Claus
"TK" <anonymous@.discussions.microsoft.com> wrote in message
news:3c9f01c4a58c$61560b90$a301280a@.phx.gbl...[vbcol=seagreen]
> I had a similar problem that was due to the server not
> using the proper TCP/IP port. I am guessing that one of
> your servers is using a different port, (or none at all),
> so it can't be seen by clients looking for the default
> port number 1433, at least that was the problem in my case.
> Check your Windows registry settings for the following
> entries, (this is the key for a default instance, but
> there are similar key paths for multiple instances):
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServ
> er\SuperSocketNetLib\Tcp\TcpPort
> This value is the port that SQL Server will listen on. In
> some cases it does not get set up correctly on the
> install. The default is a decimal value of "1433" (if it
> was blank then the server was only using shared memory
> protocol)
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\Su
> perSocketNetLib\Tcp\DefaultPort
> This value is the port that clients use to communicate
> with the server. It normally will also be "1433" (decimal).
> If you do change these values you should shut down the
> server service first and check the registry again after
> the server is running again... I had a heck of a time
> getting my server to use port 1433, as it kept switching
> to port 2433 after the server started up. (Not sure if
> it's necessary, but I also put a "" in the TcpDynamicPorts
> variable) to make sure dynamic port assignments is off.
> Alternatively, if you do have different port settings and
> need to keep them as they are, you can create alias
> entries on your clients that will associate the proper
> protocols and ports for each server.
> HTH,
> TK
> fine and the
> another server on that
> trying to connect to
> shows up and we
> the local and the
> the local one.

Cant connect via EM after changing sa password?

A client of mine changed his SA password "because it hadn't been changed in a while". :mad: Now nobody can get into Enterprise Manager - opening EM or trying to right-click > Connect on the server yields an error:

A connection could not be established to SERVER1.

Reason: login failed for user 'sa'.

Please verify SQL Server is running and check your SQL Server Registration
properties (by right-clicking on the SERVER1 node) and try again.

Of course, if I right-click on the SERVER1 node, I get the same message.

My client remembers the password he set; I managed to use it to get into Query Analyzer, which I thouhght was weird. But no luck with Enterprise Manager. It's just trying to log in as sa without prompting for a pw.

I already tried running sp_Password in Query Analyzer to change the pw back to what it was. Still can't connect to the SQL Server via Enterprise Manager.

What can I do?Did you edit the sql server registration and change the password there?

EDIT: And while I'm Here

Now nobody can get into Enterprise Manager

SCARY

Sorry Rudy|||Unclear from your post: have you tried editing the connection properties, or are you not able to get to that point?

If it won't even let you right-click on the registration to edit the properties, then try dropping the registration and creating a new one.|||Unless BUILTIN\Administrators local group is removed from SQL Server security, you can logon as a local admin or as a member of that group and easily change the SA password.