Can't get it to listen on TCP port 1433

Been having SQL Server 2000 running for some time now, but recently it stopped listening on TCP port 1433, the log reports its listening on shared memory, Named pipes and Rpc, but no sign of 127.0.0.1 port 1433 or any errors to say why it won't listen.

I've done a netstat -na and nothing else is listening on that port, tried restarting using the enterprise manager, gonna try restarting the entire Server when everyone has gone home, but I'm pretty sure its been restarted recently.

All the other archive logs going back a few days show its not listening.

Yes, I have used the Server network utility to make sure TCP/IP is enabled and set to 1433, even added a comma and 1434 to see if it will listen on multiple ports, no go.

Any help?
What service pack do you have installed?|||Have you told your firewall to allow connections to Microsoft SQL Server?|||SQL Server 2000 - 8.00.194 build 3790 Service pack 1

Mmmm, isn't SP3 out?
Lets hope it doesn't break it even more, as after the restart of the entire server last night, its now not responding to TCP connections locally 127.0.0.1

Not sure about the firewall, I'll have to check, its been fine with it for the past few years.

|||

SP4 has been out for quite some time. Here is a handy web site which lists all of the hot fix and service packs which have been released http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx.

Start by upgrading to SQL 2000 SP4. Odds are a Windows 2000 hot fix shuts down SQL from talking over the net if prior to SP3 as there is a major security flaw prior to SP3 which the SQL Slammer worm expliots.

Can't Get a Hidden Parameter to Work

I am running 2000 with SP1.
Here's what I've tried so far.
I specified no prompt in the designer (put a blank) and deployed the report.
I got the following error: Parameter validation failed. It is not possible
to provide valid values for all parameters.
I then deleted the prompt in the Report Manager and tried again. It did not
work. I then unchecked the Prompt User box, and it still did not work. In
fact, it kept filling in the prompt field with the name of the parameter.
Therefore, I had to leave the Prompt User box checked. However, for both
scenarios, I got the following error: This report requires a default or
user-defined value for the report parameter 'EmployeeId'. To run or subscribe
to this report, you must provide a parameter value.
Here is the query string I used (not using SSL yet; still testing on my own
machine):
http://<computer
name>/Reports/Pages/Report.aspx?ItemPath=/Emileage/Emileage_Aging_Report_ByEmployee&EmployeeId=0000103518
The EmployeeId is a string so I was not sure how to denote that. I have
tried this with quotes and without quotes around the EmployeeId value, and
neither works.
The employee id is the third parameter. Does it need to be the first one?
Any help would be greatly appreciated.
LizMy suggestion is to first get it working without being hidden.
Your URL is wrong. Don't use /reports use reportserver like this. It will
pull up the report but it will not if I remember correctly fill in your
parameters for you. /reports is reportmanager, the portal that ships with
RS. reportserver is the actual Reporting Services asp.net application.
http://server/reportserver?/Sales/Northwest/Employee Sales
Report&rs:Command=Render&EmployeeID=1234Also make sure your parameter name
matches your case exactly, it is (unfortunately) case sensitive.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Liz" <Liz@.discussions.microsoft.com> wrote in message
news:FB6DFF78-8495-44E0-91C5-E16D81F3BF57@.microsoft.com...
>I am running 2000 with SP1.
> Here's what I've tried so far.
> I specified no prompt in the designer (put a blank) and deployed the
> report.
> I got the following error: Parameter validation failed. It is not possible
> to provide valid values for all parameters.
> I then deleted the prompt in the Report Manager and tried again. It did
> not
> work. I then unchecked the Prompt User box, and it still did not work.
> In
> fact, it kept filling in the prompt field with the name of the parameter.
> Therefore, I had to leave the Prompt User box checked. However, for both
> scenarios, I got the following error: This report requires a default or
> user-defined value for the report parameter 'EmployeeId'. To run or
> subscribe
> to this report, you must provide a parameter value.
> Here is the query string I used (not using SSL yet; still testing on my
> own
> machine):
> http://<computer
> name>/Reports/Pages/Report.aspx?ItemPath=/Emileage/Emileage_Aging_Report_ByEmployee&EmployeeId=0000103518
> The EmployeeId is a string so I was not sure how to denote that. I have
> tried this with quotes and without quotes around the EmployeeId value, and
> neither works.
> The employee id is the third parameter. Does it need to be the first
> one?
> Any help would be greatly appreciated.
> Liz
>|||Yippee! That worked!!
Where can I get some more information on hidden parameters? I looked at the
Books Online but there is almost nothing on Reporting Services. I also have
"The Hitchhiker's Guide" which is a great book, but it doesn't have enough on
hidden parameters. I will, however, go and look at it again. I might get
more out of it this time:-)
Thanks so much!
Liz
"Bruce L-C [MVP]" wrote:
> My suggestion is to first get it working without being hidden.
> Your URL is wrong. Don't use /reports use reportserver like this. It will
> pull up the report but it will not if I remember correctly fill in your
> parameters for you. /reports is reportmanager, the portal that ships with
> RS. reportserver is the actual Reporting Services asp.net application.
> http://server/reportserver?/Sales/Northwest/Employee Sales
> Report&rs:Command=Render&EmployeeID=1234Also make sure your parameter name
> matches your case exactly, it is (unfortunately) case sensitive.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Liz" <Liz@.discussions.microsoft.com> wrote in message
> news:FB6DFF78-8495-44E0-91C5-E16D81F3BF57@.microsoft.com...
> >I am running 2000 with SP1.
> >
> > Here's what I've tried so far.
> >
> > I specified no prompt in the designer (put a blank) and deployed the
> > report.
> > I got the following error: Parameter validation failed. It is not possible
> > to provide valid values for all parameters.
> >
> > I then deleted the prompt in the Report Manager and tried again. It did
> > not
> > work. I then unchecked the Prompt User box, and it still did not work.
> > In
> > fact, it kept filling in the prompt field with the name of the parameter.
> > Therefore, I had to leave the Prompt User box checked. However, for both
> > scenarios, I got the following error: This report requires a default or
> > user-defined value for the report parameter 'EmployeeId'. To run or
> > subscribe
> > to this report, you must provide a parameter value.
> >
> > Here is the query string I used (not using SSL yet; still testing on my
> > own
> > machine):
> > http://<computer
> > name>/Reports/Pages/Report.aspx?ItemPath=/Emileage/Emileage_Aging_Report_ByEmployee&EmployeeId=0000103518
> >
> > The EmployeeId is a string so I was not sure how to denote that. I have
> > tried this with quotes and without quotes around the EmployeeId value, and
> > neither works.
> >
> > The employee id is the third parameter. Does it need to be the first
> > one?
> >
> > Any help would be greatly appreciated.
> >
> > Liz
> >
> >
>
>|||I suggest searching 2005 books on-line on the microsoft site. For things
like url integration absolutely nothing has changed between 2000 and 2005.
How you do hidden parameters I believe has changed. There are some new
features (multi-select parameters, end user sorting) but that does not
affect URL integration. They have lots of good documentation on URL
integration (was not there in the 2000 docs).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Liz" <Liz@.discussions.microsoft.com> wrote in message
news:E328C5E9-1894-4C6F-AB8A-20904F1527D6@.microsoft.com...
> Yippee! That worked!!
> Where can I get some more information on hidden parameters? I looked at
> the
> Books Online but there is almost nothing on Reporting Services. I also
> have
> "The Hitchhiker's Guide" which is a great book, but it doesn't have enough
> on
> hidden parameters. I will, however, go and look at it again. I might get
> more out of it this time:-)
> Thanks so much!
> Liz
> "Bruce L-C [MVP]" wrote:
>> My suggestion is to first get it working without being hidden.
>> Your URL is wrong. Don't use /reports use reportserver like this. It will
>> pull up the report but it will not if I remember correctly fill in your
>> parameters for you. /reports is reportmanager, the portal that ships with
>> RS. reportserver is the actual Reporting Services asp.net application.
>> http://server/reportserver?/Sales/Northwest/Employee Sales
>> Report&rs:Command=Render&EmployeeID=1234Also make sure your parameter
>> name
>> matches your case exactly, it is (unfortunately) case sensitive.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Liz" <Liz@.discussions.microsoft.com> wrote in message
>> news:FB6DFF78-8495-44E0-91C5-E16D81F3BF57@.microsoft.com...
>> >I am running 2000 with SP1.
>> >
>> > Here's what I've tried so far.
>> >
>> > I specified no prompt in the designer (put a blank) and deployed the
>> > report.
>> > I got the following error: Parameter validation failed. It is not
>> > possible
>> > to provide valid values for all parameters.
>> >
>> > I then deleted the prompt in the Report Manager and tried again. It
>> > did
>> > not
>> > work. I then unchecked the Prompt User box, and it still did not work.
>> > In
>> > fact, it kept filling in the prompt field with the name of the
>> > parameter.
>> > Therefore, I had to leave the Prompt User box checked. However, for
>> > both
>> > scenarios, I got the following error: This report requires a default
>> > or
>> > user-defined value for the report parameter 'EmployeeId'. To run or
>> > subscribe
>> > to this report, you must provide a parameter value.
>> >
>> > Here is the query string I used (not using SSL yet; still testing on my
>> > own
>> > machine):
>> > http://<computer
>> > name>/Reports/Pages/Report.aspx?ItemPath=/Emileage/Emileage_Aging_Report_ByEmployee&EmployeeId=0000103518
>> >
>> > The EmployeeId is a string so I was not sure how to denote that. I
>> > have
>> > tried this with quotes and without quotes around the EmployeeId value,
>> > and
>> > neither works.
>> >
>> > The employee id is the third parameter. Does it need to be the first
>> > one?
>> >
>> > Any help would be greatly appreciated.
>> >
>> > Liz
>> >
>> >
>>

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 PInvoke sqlceme30.dll

I am using an O2 XDA II mini running Windows Mobile 2003 SE. Tried creating a Windows Mobile 5.0 Pocket PC project but during deployment, I get this error.

Can't find PInvoke sqlceme30.dll

I have searched thru the forums and found something similar. I tried all their recommendations but no luck. Is there anything I am doing wrong? I copied the DLL files in the device's \Windows directory (sqlceme30.dll, sql*.dll...around 5 DLLs)

I would appreciate any assistance

Please install SQL Mobile CAB, do not copy these DLLs to the device manually. Also it's not clear to me why exactly you would use Windows Mobile 5.0 project for Windows Mobile 2003 device instead of using Windows Mobile 2003 project?

This error is a runtime error, not deployment error, so it appears your application was deployed OK but can not load this DLL probably because you don't have SQL Mobile CAB installed. Normally VS 2005 would install it, but since you're using wrong project type it might fail to do so.

|||

Hi Ilya,

I was just testing it out. Not really for production. I just want to make sure I am doing things right. How do you install the CAB files in the device?

|||

1. Copy CAB file to the device.

2. Click on a CAB from device file explorer.

|||I was able to install SQL Server on my device. I just did the good old restart - - - a soft reset.|||

Hello,

i had the same problem, and i think the manual installation of the CAB file will work, but isn't there a way to deploy the needed cab with the pda application (to include everything in the deployable package of the application)?

Regards

Martin

|||

Sure. It's up to you to create that package. Usually it's an MSI for a desktop which installs NETCF, SQL Mobile and your application CABs via Active Sync to the connected device.

Note: CAB in a CAB is not possible since only one instance of WCELOAD is allowed and it's already running installing first CAB.

|||In my case, the file sqlceme30.dll doesn't appear in \windows directory.

I install only the cabs "sqlce30.ppc.wce5.armv4i.CAB" and

"NETCFv2.wm.armv4i.cab", first de sql and then the framework, as VS do

when deploy.

The solution is install first the framework and after the sql. In this order "sqlceme30.dll" appear in \windows.

I have installed Compact Framework SP1 with the latest patch.|||

Yes, you have to install NETCF first. If NETCF it not detected by SQL Mobile CAB, it won't install managed provider and related files and your managed application won’t work.

Can't find PInvoke sqlceme30.dll

I am using an O2 XDA II mini running Windows Mobile 2003 SE. Tried creating a Windows Mobile 5.0 Pocket PC project but during deployment, I get this error.

Can't find PInvoke sqlceme30.dll

I have searched thru the forums and found something similar. I tried all their recommendations but no luck. Is there anything I am doing wrong? I copied the DLL files in the device's \Windows directory (sqlceme30.dll, sql*.dll...around 5 DLLs)

I would appreciate any assistance

Please install SQL Mobile CAB, do not copy these DLLs to the device manually. Also it's not clear to me why exactly you would use Windows Mobile 5.0 project for Windows Mobile 2003 device instead of using Windows Mobile 2003 project?

This error is a runtime error, not deployment error, so it appears your application was deployed OK but can not load this DLL probably because you don't have SQL Mobile CAB installed. Normally VS 2005 would install it, but since you're using wrong project type it might fail to do so.

|||

Hi Ilya,

I was just testing it out. Not really for production. I just want to make sure I am doing things right. How do you install the CAB files in the device?

|||

1. Copy CAB file to the device.

2. Click on a CAB from device file explorer.

|||I was able to install SQL Server on my device. I just did the good old restart - - - a soft reset.|||

Hello,

i had the same problem, and i think the manual installation of the CAB file will work, but isn't there a way to deploy the needed cab with the pda application (to include everything in the deployable package of the application)?

Regards

Martin

|||

Sure. It's up to you to create that package. Usually it's an MSI for a desktop which installs NETCF, SQL Mobile and your application CABs via Active Sync to the connected device.

Note: CAB in a CAB is not possible since only one instance of WCELOAD is allowed and it's already running installing first CAB.

|||In my case, the file sqlceme30.dll doesn't appear in \windows directory.

I install only the cabs "sqlce30.ppc.wce5.armv4i.CAB" and

"NETCFv2.wm.armv4i.cab", first de sql and then the framework, as VS do

when deploy.

The solution is install first the framework and after the sql. In this order "sqlceme30.dll" appear in \windows.

I have installed Compact Framework SP1 with the latest patch.|||

Yes, you have to install NETCF first. If NETCF it not detected by SQL Mobile CAB, it won't install managed provider and related files and your managed application won’t work.

Can't find odbcping.exe

I am trying to troubleshoot a SQL Server connection from my home machine
to an instance of SQL server running on my client's network using
Enterprise Manger and I am going through the steps in the MS KB article
How to troubleshoot connectivity issues in SQL Server 2000,
http://support.microsoft.com/default...;en-us;827422, which
suggests using odbcping.exe.
However, I cannot find this in my local SQL Server directories or in the
server Sql Server directories.
Doe anyone know where it is?
It's not installed by default with SQL 2000. The utility can
be found in the \x86\Binn directory on the SQL Server 2000
CD.
-Sue
On Sun, 12 Dec 2004 00:05:34 -0500, Douglas Forrest
<dforrest@.optonline.net> wrote:

>I am trying to troubleshoot a SQL Server connection from my home machine
>to an instance of SQL server running on my client's network using
>Enterprise Manger and I am going through the steps in the MS KB article
>How to troubleshoot connectivity issues in SQL Server 2000,
>http://support.microsoft.com/default...;en-us;827422, which
>suggests using odbcping.exe.
>However, I cannot find this in my local SQL Server directories or in the
>server Sql Server directories.
>Doe anyone know where it is?
|||Sue Hoegemeier wrote:
> It's not installed by default with SQL 2000. The utility can
> be found in the \x86\Binn directory on the SQL Server 2000
> CD.
> -Sue
> On Sun, 12 Dec 2004 00:05:34 -0500, Douglas Forrest
> <dforrest@.optonline.net> wrote:
>
>
Thanks

Can't even create a new SQL db, despite SQL Server 2005 installed.

I've just installed Visual Web Developer Express and SQL Server 2005. I'm running thru the painfully slow video tutorials from Microsoft (see here).

I've open Web Dev and tried to create a new SQL Database Item, only to receive this error:

"Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL http://microsoft.com"

I'm totally new to this, but this still makes no sense.

hi Brad,

only SQLExpress is designed to use User Instances, the feature you are supposed to use via all "Express editions" of Visual Studio ..

as you can see, all other SQL Server 2005 editions do not provide this feature so you have to directly code your connection to access these editions, as the builtin designers of Express editions of VS do not grant the possibility to connect to traditionals instances..

or... you can install a SQLExpress instance side by side on your pc..

regards

Cant enable SQLCacheDependency

I have a SQL 2005 database and am running the 2.0 framework. I cannot seem to enable SQL caching on the db. I'm using the command line tool as follows:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql -S 99.99.999.999 -U
webteam -P sa -t tblname -d dbname -et

Enabling the table for SQL cache dependency.

.An error has happened. Details of the exception:
The database 'dbname' is not enabled for SQL cache notification
.

To enable a database for SQL cache notification, please use the System.Web.Cachi
ng.SqlCacheDependencyAdmin.EnableNotifications method, or the command line tool
aspnet_regsql. To use the tool, please run 'aspnet_regsql.exe -?' for more infor
mation.

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>

I've replaced the ip address, dbname and tblname with ficticious names for obvious reasons here in the post.

What command can I enter to enable the database for caching?

Hi,

As show on the error message, you have to enable the cache notification on the whole database, using SqlCacheDependencyAdmin.EnableNotifications() method.

I can reproduce the error on my machine. And after calling this method, aspnet_regsql works fine.

HTH. If anything is unclear, please feel free to mark this post as Not Answered and post your reply. Thanks!

|||

Kevin, I'n not sure how to use the method you described. I tried to execute it from the command line as follows, but didn't work. It looks like I need to apply it in a .net program...

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>SqlCacheDependencyAdmin.EnableNotifications(Data Source=99.99.999.999;Initial Catalog=dbname;UserID=id;Password=pswd)
'SqlCacheDependencyAdmin.EnableNotifications' is not recognized as an internal or external command,operable program or batch file.

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>

How should I apply this method. Thanks so much...

|||

Kevin, I'n not sure how to use the method you described. I tried to execute it from the command line as follows, but didn't work. It looks like I need to apply it in a .net program...

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>SqlCacheDependencyAdmin.EnableNotifications(Data Source=99.99.999.999;Initial Catalog=dbname;UserID=id;Password=pswd)
'SqlCacheDependencyAdmin.EnableNotifications' is not recognized as an internal or external command,operable program or batch file.

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>

How should I apply this method. Thanks so much...

|||

Hi wsyeager,

This code is not executed from command line. It's a C# code.

You can create a project and execute this in the Form.Load event handler for a trial.

sql

Can't Drop table in Replication

Dear friends

I restore one database in two database servers which is running on SQL server 2000.I replicated these two through snapshot relication.Snapshot agent is creating snapshot.But when I am starting to synchronize it's telling can't drop table because that table is in replication. Backup I taken from a replicated database.so it's having rowguid both the servers.Another thing the table which it is telling not able to drop it's having primary key.please tell me what may be the problem.In replication why it is going to drop table it's only what to transport data na

Filson

The database that's restored at the subscriber probably still has replication bits set. You can clean up replication at the subscriber database by calling proc sp_removedbreplication.|||

Greg Y wrote:

The database that's restored at the subscriber probably still has replication bits set. You can clean up replication at the subscriber database by calling proc sp_removedbreplication.

I done like that.But I got a problem .I am using backup from replicated database .This backup only i restored on my publisher & subscriber.When I am subscribing three system stored procedure should be generate na for Del,Ins.Upd operations .This is not happening.I tried to delete this system generated procedures in the restored database .But it's not allowing.Then I applied replication Pubs database which is coming along with SQL Server .Then what I seen I published all Tables(10).But Stored procedure only for 5 tables is generated .in these tables whatever changes i am making it's affecting through Replication,Example publisher table in pubs database is not getting any stored procedure after subscription.So it's not getting any change through replication.Then I am getting error message'procedure Sp_MsIns_Publisher not found'.So please tell me what to do remove all old Stored procedures for replication in restored database and how to create the stored procedures for all the tables published

Thanks in Advance

Filson

|||

You need to restore the database at the subscriber and remove all replication components. When using the wizard to set up the subscription, specify the option that the subscriber has the data. if you're doing it via TSQL, then specify 'nosync' for paramter @.sync_type in sp_addsubscription. After the first sync, you can then run sp_scriptpublicationcustomprocs at the subscriber to create the necessary procs for the distribution agent.

|||

Greg Y wrote:

You need to restore the database at the subscriber and remove all replication components. When using the wizard to set up the subscription, specify the option that the subscriber has the data. if you're doing it via TSQL, then specify 'nosync' for paramter @.sync_type in sp_addsubscription. After the first sync, you can then run sp_scriptpublicationcustomprocs at the subscriber to create the necessary procs for the distribution agent.

Greg thanks for suggestion.Previously itself I tried these ways to remove replication components.But still System stored procedures for table Ins,Del,Upd is not dropping.I want a specific way to drop it out.I think i mentioned this in earlier post.So kindly suggest me a better way for that

Filson

|||Sorry, it's not clear to me what the problem is. Are you trying to drop or create the sp_MSins/upd/del stored procedures? And where - at the publisher or subscriber? I'm not too familiar with SQL 2000, maybe you have to manually delete these stored procedures.|||

Greg Y wrote:

Sorry, it's not clear to me what the problem is. Are you trying to drop or create the sp_MSins/upd/del stored procedures? And where - at the publisher or subscriber? I'm not too familiar with SQL 2000, maybe you have to manually delete these stored procedures.

I am describing my problem below .I taken a backup of replicated database.That I restored on another server.I made that one as a publisher.Another instance I made as a subscriber.I restored same database on this subscriber.Then I tried for transactional replication.While synchronizing I got error on my subscriber 'Sp_MsIns_AgentCode is not found'.This I got while Inserting records to AgentCode Table in publisher.Then I come to know for each table article published in Transactional replication will have three system generated stored procedures 1)insertion 2)updation 3)Deletion.This is not generating when i subscribing to my publisher..Here when I am pulling the subscription I am specifying 'No Shema & data transfer'.So I am not able to transport this System generated Procedures.If I am selecting 'Schema & data Tansfer'.It won't able to initialize in subscriber due to Foreign Key criterias. after completing Subscription through Wizard,Can I trnsfer UPD,INS,DEL Procedure Schema through any Sp_procedure call? Give me some better way

Filson

|||

I mentioned above to run stored procedure sp_scriptpublicationcustomprocs at the subscriber database after applying the snapshot, did you do that? That proc is supposed to generate the missing sp_MSins/upd/del procs that the distribution agent is trying to execute.

Can't drop SQL Mobile subscription at Publisher

I have a program running on Pocket PCs that synchronizes with a desktop SQL database using SQL Mobile. My problem is that I can't delete old subscriptions from the publication; now the publication has 25 subscriptions and won't accept any more (limit of SQL Workgroup edition). I can delete non-SQL Mobile subcriptions just fine.

Running sp_replmonitorhelpsubscription provides this information:

subscriber: LVCONTACTSMERGE - 5FA305234F0C
subscriber_db: Program Files\PocketLVContacts\LVContacts.sdf
publisher_db: LVContacts
publication: LVContactsMerge

So I set up this bit of code:

USE LVContacts
EXEC sp_dropmergesubscription
@.publication = 'LVContactsMerge',
@.subscriber = 'LVCONTACTSMERGE - 5FA305234F0C',
@.subscriber_db = 'Program Files\PocketLVContacts\LVContacts.sdf',
@.subscription_type='all';
GO

No errors are reported, but the subscription doesn't get deleted.

I've tried shutting down SQL Server Agent (mentioned in another thread); makes no difference.

Any ideas?

--Evan

If you query sysmergesubscriptions, do you get the same values returned as|||

If you query sysmergesubscriptions, do you get the same values returned as sp_replmonitorhelpsubscription? I'm just wondering if the subscriber_db name returned is correct or not.

|||

Yes, both sysmergesubscriptions and sp_replmonitorhelpsubscription give the same subscriber_db name. Note that the name returned, i.e. 'Program Files\PocketLVContacts\LVContactsData.sdf', is the path on the mobile device.

I wonder if it is safe to manually delete a row from sysmergesubscriptions. It seems to work, but no Distributor clean-up is done.

|||

I've found where I was going wrong. The code I cited in my original post DOES work, but to see the changes you must use sysmergesubscriptions, NOT sp_replmonitorhelpsubscription. The latter apparently reflects the distribution database, which is not cleaned up when you use sp_dropmergesubscription.

When you use SQL Server Management Studio to delete a subscription on a mobile device running SQL Mobile, the subscription on the Publisher is NOT also deleted; you must do it manually (or wait until the subscription expires). But it is difficult to determine which subscription on the Publisher corresponds to the one you want to delete on the mobile Subscriber. What I did was first query the mobile Subscriber system table __sysMergeSubscriptions, note the SubscriptionID field, then query the sysmergesubscriptions on the Publisher database, and find the row with a SubID that matches. Then you can run sp_dropmergesubscription using the subscriber_server field as @.subscriber and the db_name field as @.subscriber_db.

Cant Delete database

I am running sql server 2000. I have one database that I
cant delete. It says its in use when I try to delete it or
de-attach it. Its not in use by anyone but still wont let
me delete it. What am I missing?Hi,
Make sure that the database, indeed, is not in use by executing the below
command and check under 'dbname' column.
sp_who
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"JR" <anonymous@.discussions.microsoft.com> wrote in message
news:eba501c43cf6$07eadb70$a501280a@.phx.gbl...
> I am running sql server 2000. I have one database that I
> cant delete. It says its in use when I try to delete it or
> de-attach it. Its not in use by anyone but still wont let
> me delete it. What am I missing?|||Your own connection? If you are in Query Analyzer and you are in the
context of databaseA, you cannot drop databaseA. You need to switch to
master or some other database before dropping it, so that your context is
not preventing such activity.
If it is not your own connection, then use sp_who2 to determine which SPIDs
are connected to the database, who they belong to, and what they are doing.
If you can't determine who they are, or couldn't be bothered, you can set
the database to single_user and kick everyone out forcibly.
For detailed information please see http://www.aspfaq.com/2518
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"JR" <anonymous@.discussions.microsoft.com> wrote in message
news:eba501c43cf6$07eadb70$a501280a@.phx.gbl...
> I am running sql server 2000. I have one database that I
> cant delete. It says its in use when I try to delete it or
> de-attach it. Its not in use by anyone but still wont let
> me delete it. What am I missing?|||Hi,
Use the below script to drop the database.
use master
go
Alter database <dbname> set single_user with rollback immediate
go
drop database <dbname>
Thanks
Hari
MCDBA
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OyFGAfPPEHA.2444@.TK2MSFTNGP12.phx.gbl...
> Your own connection? If you are in Query Analyzer and you are in the
> context of databaseA, you cannot drop databaseA. You need to switch to
> master or some other database before dropping it, so that your context is
> not preventing such activity.
> If it is not your own connection, then use sp_who2 to determine which
SPIDs
> are connected to the database, who they belong to, and what they are
doing.
> If you can't determine who they are, or couldn't be bothered, you can set
> the database to single_user and kick everyone out forcibly.
> For detailed information please see http://www.aspfaq.com/2518
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "JR" <anonymous@.discussions.microsoft.com> wrote in message
> news:eba501c43cf6$07eadb70$a501280a@.phx.gbl...
> > I am running sql server 2000. I have one database that I
> > cant delete. It says its in use when I try to delete it or
> > de-attach it. Its not in use by anyone but still wont let
> > me delete it. What am I missing?
>|||Did you mean to reply to me?
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:umYwx4UPEHA.1160@.TK2MSFTNGP09.phx.gbl...
> Hi,|||No Aaron, its for the person (JR) who posted the question.
Thanks
Hari
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:usywR8VPEHA.308@.TK2MSFTNGP11.phx.gbl...
> Did you mean to reply to me?
>
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:umYwx4UPEHA.1160@.TK2MSFTNGP09.phx.gbl...
> > Hi,
>

Cant Delete database

I am running sql server 2000. I have one database that I
cant delete. It says its in use when I try to delete it or
de-attach it. Its not in use by anyone but still wont let
me delete it. What am I missing?
Hi,
Make sure that the database, indeed, is not in use by executing the below
command and check under 'dbname' column.
sp_who
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"JR" <anonymous@.discussions.microsoft.com> wrote in message
news:eba501c43cf6$07eadb70$a501280a@.phx.gbl...
> I am running sql server 2000. I have one database that I
> cant delete. It says its in use when I try to delete it or
> de-attach it. Its not in use by anyone but still wont let
> me delete it. What am I missing?
|||Your own connection? If you are in Query Analyzer and you are in the
context of databaseA, you cannot drop databaseA. You need to switch to
master or some other database before dropping it, so that your context is
not preventing such activity.
If it is not your own connection, then use sp_who2 to determine which SPIDs
are connected to the database, who they belong to, and what they are doing.
If you can't determine who they are, or couldn't be bothered, you can set
the database to single_user and kick everyone out forcibly.
For detailed information please see http://www.aspfaq.com/2518
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"JR" <anonymous@.discussions.microsoft.com> wrote in message
news:eba501c43cf6$07eadb70$a501280a@.phx.gbl...
> I am running sql server 2000. I have one database that I
> cant delete. It says its in use when I try to delete it or
> de-attach it. Its not in use by anyone but still wont let
> me delete it. What am I missing?
|||Hi,
Use the below script to drop the database.
use master
go
Alter database <dbname> set single_user with rollback immediate
go
drop database <dbname>
Thanks
Hari
MCDBA
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OyFGAfPPEHA.2444@.TK2MSFTNGP12.phx.gbl...
> Your own connection? If you are in Query Analyzer and you are in the
> context of databaseA, you cannot drop databaseA. You need to switch to
> master or some other database before dropping it, so that your context is
> not preventing such activity.
> If it is not your own connection, then use sp_who2 to determine which
SPIDs
> are connected to the database, who they belong to, and what they are
doing.
> If you can't determine who they are, or couldn't be bothered, you can set
> the database to single_user and kick everyone out forcibly.
> For detailed information please see http://www.aspfaq.com/2518
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "JR" <anonymous@.discussions.microsoft.com> wrote in message
> news:eba501c43cf6$07eadb70$a501280a@.phx.gbl...
>
|||Did you mean to reply to me?
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:umYwx4UPEHA.1160@.TK2MSFTNGP09.phx.gbl...
> Hi,
|||No Aaron, its for the person (JR) who posted the question.
Thanks
Hari
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:usywR8VPEHA.308@.TK2MSFTNGP11.phx.gbl...
> Did you mean to reply to me?
>
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:umYwx4UPEHA.1160@.TK2MSFTNGP09.phx.gbl...
>

Cant Delete database

I am running sql server 2000. I have one database that I
cant delete. It says its in use when I try to delete it or
de-attach it. Its not in use by anyone but still wont let
me delete it. What am I missing?Hi,
Make sure that the database, indeed, is not in use by executing the below
command and check under 'dbname' column.
sp_who
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"JR" <anonymous@.discussions.microsoft.com> wrote in message
news:eba501c43cf6$07eadb70$a501280a@.phx.gbl...
> I am running sql server 2000. I have one database that I
> cant delete. It says its in use when I try to delete it or
> de-attach it. Its not in use by anyone but still wont let
> me delete it. What am I missing?|||Your own connection? If you are in Query Analyzer and you are in the
context of databaseA, you cannot drop databaseA. You need to switch to
master or some other database before dropping it, so that your context is
not preventing such activity.
If it is not your own connection, then use sp_who2 to determine which SPIDs
are connected to the database, who they belong to, and what they are doing.
If you can't determine who they are, or couldn't be bothered, you can set
the database to single_user and kick everyone out forcibly.
For detailed information please see http://www.aspfaq.com/2518
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"JR" <anonymous@.discussions.microsoft.com> wrote in message
news:eba501c43cf6$07eadb70$a501280a@.phx.gbl...
> I am running sql server 2000. I have one database that I
> cant delete. It says its in use when I try to delete it or
> de-attach it. Its not in use by anyone but still wont let
> me delete it. What am I missing?|||Hi,
Use the below script to drop the database.
use master
go
Alter database <dbname> set single_user with rollback immediate
go
drop database <dbname>
Thanks
Hari
MCDBA
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OyFGAfPPEHA.2444@.TK2MSFTNGP12.phx.gbl...
> Your own connection? If you are in Query Analyzer and you are in the
> context of databaseA, you cannot drop databaseA. You need to switch to
> master or some other database before dropping it, so that your context is
> not preventing such activity.
> If it is not your own connection, then use sp_who2 to determine which
SPIDs
> are connected to the database, who they belong to, and what they are
doing.
> If you can't determine who they are, or couldn't be bothered, you can set
> the database to single_user and kick everyone out forcibly.
> For detailed information please see http://www.aspfaq.com/2518
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "JR" <anonymous@.discussions.microsoft.com> wrote in message
> news:eba501c43cf6$07eadb70$a501280a@.phx.gbl...
>|||Did you mean to reply to me?
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:umYwx4UPEHA.1160@.TK2MSFTNGP09.phx.gbl...
> Hi,|||No Aaron, its for the person (JR) who posted the question.
Thanks
Hari
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:usywR8VPEHA.308@.TK2MSFTNGP11.phx.gbl...
> Did you mean to reply to me?
>
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:umYwx4UPEHA.1160@.TK2MSFTNGP09.phx.gbl...
>

Can't create Merge Publication

I have been trying for some time to create a Merge publication in SQL Server. I'm running SQL Server 2000 Standard Edition with the latest service pack on a Win2k3 Server. It doesn't seem to matter what replication-enabled database or which table I select
, I always get the same error at the end of the create publication wizard in Enterprise Mgr: "Error 2758 RAISERROR could not locate entry for error 21423 in sysmessages. Object 'pubs' (note: or whatever db I select) does not exist or is not a valid object
for this operation."
Any ideas here?
Corey - possibly this is an incomplete service pack install as some messages
in sysmessages are missing. You could have a look at sqlsp.log file from the
c:\windows directory which might shed some light on any failed actions
during the sp installation. Even if there isn't anything enlightening there
I'd reapply the sp3a.
HTH,
Paul Ibison
|||Thanks, Paul, but so far no luck. I dug through the log and didn't find anything all that revealing. I also re-applied SP3a, but that didn't help either. Still searching...
"Paul Ibison" wrote:

> Corey - possibly this is an incomplete service pack install as some messages
> in sysmessages are missing. You could have a look at sqlsp.log file from the
> c:\windows directory which might shed some light on any failed actions
> during the sp installation. Even if there isn't anything enlightening there
> I'd reapply the sp3a.
> HTH,
> Paul Ibison
>
>
|||Corey,
in htis case you could rebuild the master database or alternatively just add
the missing messages. To do the latter you'll need to create a linked server
to another server that has a complete master database and join to that table
(left outer join) to find the missing messages in sysmessages.
HTH,
Paul Ibison

Cant create connection to database

I am having trouble creating a connection to an MS SQL 2000 database located on a server at the hosting company I'm using, with code running from my localhost. It works when the code is executed on the server at my hosting company, but not when it is executed locally, on my computer. Also, I can't connect to the database using Enterprise Manager. The error I get is this:

SQL Server does not exist or access denied

It has worked before, so I don't understand why it doesn't anymore. It's not a firewall issue, since I have tried to connect with my firewall disabled as well.

Any tips or ideas?have you tried those obvious things like using ip in place of server name? when this error appears and there is evidence that the server is running and nothinng is misspelled it just means that the network library selected is not the one that can reach the target (that's lame interpretation, i'm sure there'll be someone to take the trouble to translate it into unreadable scientific terms ;))|||Yup, have tried using IP instead. No luck.|||Your problem may be as simple as the SQL Server installation being on a dynamic port or as complex as a problem with the hosting companies firewall. Have you tried connecting the hosting company and asking them for outside connection parameters?

Randy
www.Database-Security.Info|||Yes, I have contacted them. Several times. And the say that they can connect to the database (on port 1433) from an external network, using the exact same username and password I'm using.

Can't connet to MSDE with Query Analyzer

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied
I've tried by creating a new account with owner rights to all databases and
I still get the same error when connecting with Query Analyzer. When I get
the "Connect to SQL Server" dialog box I can see the server but when I enter
the user name an password it gives me the error message.
The client is attempting to connect using TCP/IP so you will
want to make sure this protocol is enabled for MSDE. You can
use the server network utility to check, enable the
protocols. The utility file name is svrnetcn.exe. You can
find it in the Tools\Binn directory of your installation
path.
You can also find some general troubleshooting for the error
at:
INF: Potential Causes of the "SQL Server Does Not Exist or
Access Denied" Error Message
http://support.microsoft.com/?id=328306
-Sue
On Sun, 2 May 2004 16:00:49 -0500, "Sal Young"
<salyoung@.comcast.net> wrote:

>I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
>a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
>firewall to connect the two computers and I'm getting the following error:
>Unable to connec to server SERVERNAME
>Server: Msg 17, Level 16, State1
>[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
>access denied
>
>I've tried by creating a new account with owner rights to all databases and
>I still get the same error when connecting with Query Analyzer. When I get
>the "Connect to SQL Server" dialog box I can see the server but when I enter
>the user name an password it gives me the error message.
>

Can't connet to MSDE with Query Analyzer

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or
access denied
I've tried by creating a new account with owner rights to all databases and
I still get the same error when connecting with Query Analyzer. When I get
the "Connect to SQL Server" dialog box I can see the server but when I enter
the user name an password it gives me the error message.Hi Sal,
Try creating a Test ODBC DSN to the MSDE server. Then review the OS
Error returned.
This will help troubleshoot the problem.
Example:
10060 = Connection Timeout
11001 = Host not found.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.