Microsoft SQL server 2005, connection string

<

connectionStrings>

<

addname="AppConnectionString1"connectionString="Data Source=".\SQLEXPRESS";AttachDbFilename="C:\Program Files\Microsoft SQL Server\MSSQL\Data\AdventureWorks2000_Data.mdf";Integrated Security=True"providerName="System.Data.SqlClient" />

</

connectionStrings>

I'm running Microsoft SQL server 2005. what is the error in the above code.

What is the error that you are getting?|||

a database not found error message.

here's some background:

I've followed the instructions here :http://msdn2.microsoft.com/library/ms310325.aspx as before, and everything went well till.

"To configure AdventureWorks to work with Web server controls"

sqlcmd -E -S (local)\sqlexpress -Q "sp_grantlogin N'NT AUTHORITY\NETWORK SERVICE'"

My machine name is Leigh, i run win xp home edition, and MS SQL server 2005, so the above command in my case should be :

sqlcmd -E -S (local)\sqlexpress -Q "sp_grantlogin N' Leigh\ASPNET'" ? (which doesn't work i assume because not happens )

Microsoft OLE DB Provider for SQL Server error '80004005'

Hello Group,

I need some help in the worst way. I had a program/database I was working on a particular machine. I took all the data from there and placed it on a another machine. Now I'm unable to navigate through the web pages on the new machine. I am getting the error...

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

......asp, line 19

Can you please help!!

Quote:

Originally Posted by ConfusedDeuce

Hello Group,

I need some help in the worst way. I had a program/database I was working on a particular machine. I took all the data from there and placed it on a another machine. Now I'm unable to navigate through the web pages on the new machine. I am getting the error...

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

......asp, line 19

Can you please help!!

On line 19, your connection to the database is failing. Are you on the same network segment/subnet as you previously were? What is the physical difference between the computers?|||

Quote:

Originally Posted by ConfusedDeuce

Hello Group,

I need some help in the worst way. I had a program/database I was working on a particular machine. I took all the data from there and placed it on a another machine. Now I'm unable to navigate through the web pages on the new machine. I am getting the error...

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

......asp, line 19

Can you please help!!

How are you now specifying the server name when connecting to this machine?
You'll need to allow the server port on that new machine if it's running a firewall.|||

Quote:

Originally Posted by Motoma

On line 19, your connection to the database is failing. Are you on the same network segment/subnet as you previously were? What is the physical difference between the computers?

The thing is that I'm not completely sure what the other machine had on it because they data was copied over from that machine and the machine was immediately taken away. Now I am using VMWare and virtually connected to new machine (which shouldnt be the problem). I'm not sure of any of the specs of the last machine : (|||

Quote:

Originally Posted by r035198x

How are you now specifying the server name when connecting to this machine?
You'll need to allow the server port on that new machine if it's running a firewall.

I'm not connecting to the old machine anymore. That machine is out of the office and no longer in physical reach.|||

Quote:

Originally Posted by ConfusedDeuce

The thing is that I'm not completely sure what the other machine had on it because they data was copied over from that machine and the machine was immediately taken away. Now I am using VMWare and virtually connected to new machine (which shouldnt be the problem). I'm not sure of any of the specs of the last machine : (

Do you have the SQL Server database up and running on the new machine? Have you added the appropriate accounts and permissions for the users?|||

Quote:

Originally Posted by Motoma

Do you have the SQL Server database up and running on the new machine? Have you added the appropriate accounts and permissions for the users?

Yes it is up and running. How do i add the accounts and permissions?|||

Quote:

Originally Posted by ConfusedDeuce

Yes it is up and running. How do i add the accounts and permissions?

Enterprise Manager -> Server -> Security -> Logins
Enterprise Manager -> Server -> Databases -> Database -> Users
Enterprise Manager -> Server -> Databases -> Database -> Roles|||

Quote:

Originally Posted by ConfusedDeuce

I'm not connecting to the old machine anymore. That machine is out of the office and no longer in physical reach.

Actually I was refering to that new machine. That error means that the connection to the database server was not done correctly. The reasons could be
wrong hostname being specified
firewall blocking connections
change of IP
wrong port being used or break in TCP/IP conection while accessing the database server
e.t.c

Microsoft OLE DB Provider for ODBC Drivers error 80040e14

Hi guys, it's nice to join the forum. Can someone can help me?

After 2 years of using a program, i suddenly got this error. I tried
re-installing SQL but im still getting the message.

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot load the DLL
xplog70.dll, or one of the DLLs it references. Reason: 193(error not
found).Albert (albert@.extremerack.com) writes:
> Hi guys, it's nice to join the forum. Can someone can help me?
> After 2 years of using a program, i suddenly got this error. I tried
> re-installing SQL but im still getting the message.
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot load the DLL
> xplog70.dll, or one of the DLLs it references. Reason: 193(error not
> found).

That's an error on the SQL Server side, occurring when calling some
extended stored procedure, which is implmented by the xplog70.dll. I
don't know what exactly is in this DLL, but it appears that xp_logevent
is there.

If there is no requirement for high availability, the easiest may be
to restart SQL Server or even reboot the SQL Server machine to see if that
helps.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Microsoft Customer Experience Improvement Program is annoying

Microsoft Customer Experience Improvement Program is annoying
How do I turn this annoying thing off for god’s sake?
I check NO, I don’t wish to participate. But it keeps popping up asking me
to make SQL server better.
When you're in "SQL Server Management Studio" click Help then choose
"Customer Feedback Options"
HTH. Ryan
"letuce dance" <letucedance@.discussions.microsoft.com> wrote in message
news:377BFDCD-B914-4F40-914A-3874A6198858@.microsoft.com...
> Microsoft Customer Experience Improvement Program is annoying
> How do I turn this annoying thing off for god's sake?
> I check NO, I don't wish to participate. But it keeps popping up asking
> me
> to make SQL server better.
>
|||It is checked
"NO I DON'T WISH TO PARTICIPANT"
But it still keeps asking me from time to time if I want to make SQL server
better.
What gives? Can I uninstall this spam spyware feature of the product?

Microsoft Customer Experience Improvement Program is annoying

Microsoft Customer Experience Improvement Program is annoying
How do I turn this annoying thing off for god’s sake?
I check NO, I don’t wish to participate. But it keeps popping up asking m
e
to make SQL server better.When you're in "SQL Server Management Studio" click Help then choose
"Customer Feedback Options"
HTH. Ryan
"letuce dance" <letucedance@.discussions.microsoft.com> wrote in message
news:377BFDCD-B914-4F40-914A-3874A6198858@.microsoft.com...
> Microsoft Customer Experience Improvement Program is annoying
> How do I turn this annoying thing off for god's sake?
> I check NO, I don't wish to participate. But it keeps popping up asking
> me
> to make SQL server better.
>|||It is checked
"NO I DON'T WISH TO PARTICIPANT"
But it still keeps asking me from time to time if I want to make SQL server
better.
What gives? Can I uninstall this spam spyware feature of the product?

Microsoft Customer Experience Improvement Program is annoying

Microsoft Customer Experience Improvement Program is annoying
How do I turn this annoying thing off for godâ's sake?
I check NO, I donâ't wish to participate. But it keeps popping up asking me
to make SQL server better.When you're in "SQL Server Management Studio" click Help then choose
"Customer Feedback Options"
--
HTH. Ryan
"letuce dance" <letucedance@.discussions.microsoft.com> wrote in message
news:377BFDCD-B914-4F40-914A-3874A6198858@.microsoft.com...
> Microsoft Customer Experience Improvement Program is annoying
> How do I turn this annoying thing off for god's sake?
> I check NO, I don't wish to participate. But it keeps popping up asking
> me
> to make SQL server better.
>|||It is checked
"NO I DON'T WISH TO PARTICIPANT"
But it still keeps asking me from time to time if I want to make SQL server
better.
What gives? Can I uninstall this spam spyware feature of the product?

Microsoft ASP Licensing Program for SQL Server

I own and run a small ASP that provides membership management services to
non-profit organizations. Currently I host my application on a dedicated
Windows Server 2003 machine at a hosting provider. The application is
..NET-based and makes use of SQL Server databases on a shared SQL Server
machine at said hosting provider.
I have recently been encountering limitations with this usage of SQL
databases on a shared machine. I am ready to purchase my own SQL Server
license. It looks like a per-processor license is the way to go. Because I am
a small operation, I cannot afford outright purchase of SQL Server Enterprise
Edition ($19,000-plus for 1 processor) or SQL Server 2000 Standard Edition
($4,700-plus for 1 processor).
It looks like the program for me may be the Microsoft ASP Licensing Program,
which appears to offer a monthly bill for a SQL Server per-processor license.
But I'm not getting good answers on this program from the published
materials. In particular, my questions are:
1) Is my company eligible for this program? We are a Registered Member in
the Empower Program for ISVs. (Microsoft's "ASP Strategy Whitepaper" says a
company must be a Microsoft Certified Solution Provider to buy from the ASP
Licensing Program. Is this a hoop I need to jump through to buy SQL Server on
the ASP plan?)
2) What is the pricing for this program?
Any help you can offer on these questions would be appreciated.
rxsullivan wrote:
> I own and run a small ASP that provides membership management
You should contact Microsoft directly for this question.
David Gugick
Imceda Software
www.imceda.com
|||I agree that you should contact your local MS office for this. In
Australiia, this particular area is looked after by a "Regional Hosting
Specialist", but he's mainly interested in the SPLA licensing you're
referring to. Make sure you look up what's available to you through your ISV
contacts as my experience is that in some cases, these guys can sometimes
save you more money than through SPLA, especially if you're a leading
product in your field.
What country are you in? I'd be happy to ping my local contact to see if I
can help get you connected.
Regards,
Greg Linwood
SQL Server MVP
"rxsullivan" <rxsullivan@.discussions.microsoft.com> wrote in message
news:A6B1CA2D-E162-477E-A1E9-B2E9EBBEE40A@.microsoft.com...
>I own and run a small ASP that provides membership management services to
> non-profit organizations. Currently I host my application on a dedicated
> Windows Server 2003 machine at a hosting provider. The application is
> .NET-based and makes use of SQL Server databases on a shared SQL Server
> machine at said hosting provider.
> I have recently been encountering limitations with this usage of SQL
> databases on a shared machine. I am ready to purchase my own SQL Server
> license. It looks like a per-processor license is the way to go. Because I
> am
> a small operation, I cannot afford outright purchase of SQL Server
> Enterprise
> Edition ($19,000-plus for 1 processor) or SQL Server 2000 Standard Edition
> ($4,700-plus for 1 processor).
> It looks like the program for me may be the Microsoft ASP Licensing
> Program,
> which appears to offer a monthly bill for a SQL Server per-processor
> license.
> But I'm not getting good answers on this program from the published
> materials. In particular, my questions are:
> 1) Is my company eligible for this program? We are a Registered Member in
> the Empower Program for ISVs. (Microsoft's "ASP Strategy Whitepaper" says
> a
> company must be a Microsoft Certified Solution Provider to buy from the
> ASP
> Licensing Program. Is this a hoop I need to jump through to buy SQL Server
> on
> the ASP plan?)
> 2) What is the pricing for this program?
> Any help you can offer on these questions would be appreciated.

Microsoft ASP Licensing Program for SQL Server

I own and run a small ASP that provides membership management services to
non-profit organizations. Currently I host my application on a dedicated
Windows Server 2003 machine at a hosting provider. The application is
.NET-based and makes use of SQL Server databases on a shared SQL Server
machine at said hosting provider.
I have recently been encountering limitations with this usage of SQL
databases on a shared machine. I am ready to purchase my own SQL Server
license. It looks like a per-processor license is the way to go. Because I am
a small operation, I cannot afford outright purchase of SQL Server Enterprise
Edition ($19,000-plus for 1 processor) or SQL Server 2000 Standard Edition
($4,700-plus for 1 processor).
It looks like the program for me may be the Microsoft ASP Licensing Program,
which appears to offer a monthly bill for a SQL Server per-processor license.
But I'm not getting good answers on this program from the published
materials. In particular, my questions are:
1) Is my company eligible for this program? We are a Registered Member in
the Empower Program for ISVs. (Microsoft's "ASP Strategy Whitepaper" says a
company must be a Microsoft Certified Solution Provider to buy from the ASP
Licensing Program. Is this a hoop I need to jump through to buy SQL Server on
the ASP plan?)
2) What is the pricing for this program?
Any help you can offer on these questions would be appreciated.rxsullivan wrote:
> I own and run a small ASP that provides membership management
You should contact Microsoft directly for this question.
--
David Gugick
Imceda Software
www.imceda.com|||I agree that you should contact your local MS office for this. In
Australiia, this particular area is looked after by a "Regional Hosting
Specialist", but he's mainly interested in the SPLA licensing you're
referring to. Make sure you look up what's available to you through your ISV
contacts as my experience is that in some cases, these guys can sometimes
save you more money than through SPLA, especially if you're a leading
product in your field.
What country are you in? I'd be happy to ping my local contact to see if I
can help get you connected.
Regards,
Greg Linwood
SQL Server MVP
"rxsullivan" <rxsullivan@.discussions.microsoft.com> wrote in message
news:A6B1CA2D-E162-477E-A1E9-B2E9EBBEE40A@.microsoft.com...
>I own and run a small ASP that provides membership management services to
> non-profit organizations. Currently I host my application on a dedicated
> Windows Server 2003 machine at a hosting provider. The application is
> .NET-based and makes use of SQL Server databases on a shared SQL Server
> machine at said hosting provider.
> I have recently been encountering limitations with this usage of SQL
> databases on a shared machine. I am ready to purchase my own SQL Server
> license. It looks like a per-processor license is the way to go. Because I
> am
> a small operation, I cannot afford outright purchase of SQL Server
> Enterprise
> Edition ($19,000-plus for 1 processor) or SQL Server 2000 Standard Edition
> ($4,700-plus for 1 processor).
> It looks like the program for me may be the Microsoft ASP Licensing
> Program,
> which appears to offer a monthly bill for a SQL Server per-processor
> license.
> But I'm not getting good answers on this program from the published
> materials. In particular, my questions are:
> 1) Is my company eligible for this program? We are a Registered Member in
> the Empower Program for ISVs. (Microsoft's "ASP Strategy Whitepaper" says
> a
> company must be a Microsoft Certified Solution Provider to buy from the
> ASP
> Licensing Program. Is this a hoop I need to jump through to buy SQL Server
> on
> the ASP plan?)
> 2) What is the pricing for this program?
> Any help you can offer on these questions would be appreciated.

Microsoft ASP Licensing Program for SQL Server

I own and run a small ASP that provides membership management services to
non-profit organizations. Currently I host my application on a dedicated
Windows Server 2003 machine at a hosting provider. The application is
.NET-based and makes use of SQL Server databases on a shared SQL Server
machine at said hosting provider.
I have recently been encountering limitations with this usage of SQL
databases on a shared machine. I am ready to purchase my own SQL Server
license. It looks like a per-processor license is the way to go. Because I a
m
a small operation, I cannot afford outright purchase of SQL Server Enterpris
e
Edition ($19,000-plus for 1 processor) or SQL Server 2000 Standard Edition
($4,700-plus for 1 processor).
It looks like the program for me may be the Microsoft ASP Licensing Program,
which appears to offer a monthly bill for a SQL Server per-processor license
.
But I'm not getting good answers on this program from the published
materials. In particular, my questions are:
1) Is my company eligible for this program? We are a Registered Member in
the Empower Program for ISVs. (Microsoft's "ASP Strategy Whitepaper" says a
company must be a Microsoft Certified Solution Provider to buy from the ASP
Licensing Program. Is this a hoop I need to jump through to buy SQL Server o
n
the ASP plan?)
2) What is the pricing for this program?
Any help you can offer on these questions would be appreciated.rxsullivan wrote:
> I own and run a small ASP that provides membership management
You should contact Microsoft directly for this question.
David Gugick
Imceda Software
www.imceda.com|||I agree that you should contact your local MS office for this. In
Australiia, this particular area is looked after by a "Regional Hosting
Specialist", but he's mainly interested in the SPLA licensing you're
referring to. Make sure you look up what's available to you through your ISV
contacts as my experience is that in some cases, these guys can sometimes
save you more money than through SPLA, especially if you're a leading
product in your field.
What country are you in? I'd be happy to ping my local contact to see if I
can help get you connected.
Regards,
Greg Linwood
SQL Server MVP
"rxsullivan" <rxsullivan@.discussions.microsoft.com> wrote in message
news:A6B1CA2D-E162-477E-A1E9-B2E9EBBEE40A@.microsoft.com...
>I own and run a small ASP that provides membership management services to
> non-profit organizations. Currently I host my application on a dedicated
> Windows Server 2003 machine at a hosting provider. The application is
> .NET-based and makes use of SQL Server databases on a shared SQL Server
> machine at said hosting provider.
> I have recently been encountering limitations with this usage of SQL
> databases on a shared machine. I am ready to purchase my own SQL Server
> license. It looks like a per-processor license is the way to go. Because I
> am
> a small operation, I cannot afford outright purchase of SQL Server
> Enterprise
> Edition ($19,000-plus for 1 processor) or SQL Server 2000 Standard Edition
> ($4,700-plus for 1 processor).
> It looks like the program for me may be the Microsoft ASP Licensing
> Program,
> which appears to offer a monthly bill for a SQL Server per-processor
> license.
> But I'm not getting good answers on this program from the published
> materials. In particular, my questions are:
> 1) Is my company eligible for this program? We are a Registered Member in
> the Empower Program for ISVs. (Microsoft's "ASP Strategy Whitepaper" says
> a
> company must be a Microsoft Certified Solution Provider to buy from the
> ASP
> Licensing Program. Is this a hoop I need to jump through to buy SQL Server
> on
> the ASP plan?)
> 2) What is the pricing for this program?
> Any help you can offer on these questions would be appreciated.

Microsft Development Environment - Missing Toolbox Items

Hi,
I had some problems with the MDE application used to create reporting services reports, and rectified the problem by running the program with the command switch /resetskippkgs. Since doing this, my toolbox has lost all the controls used to design a reporting services report (e.g. Matrix, Table, Image etc).
Anyone know how I can get these back? I've tried doing a repair on the installation of the application, but no joy.
Thanks.
SimonRight-click in the toolbox, choose Add/Remove Items, and click the Reset
button.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:F7117049-4270-49A4-A9D0-08CDAB6D70A9@.microsoft.com...
> Hi,
> I had some problems with the MDE application used to create reporting
services reports, and rectified the problem by running the program with the
command switch /resetskippkgs. Since doing this, my toolbox has lost all
the controls used to design a reporting services report (e.g. Matrix, Table,
Image etc).
> Anyone know how I can get these back? I've tried doing a repair on the
installation of the application, but no joy.
> Thanks.
> Simon

Micorsoft ActiveX Data object could not be loaded

Hi all,

I wanna use the Microsoft ActiveX Data Object (Multi-dimensional)2.6 Library component
in my VB application, but it returns:
" 'C:\Program Files\Common Files\System\ado\msadomd.dll' could not be loaded "

How to solve this problem?
I am using:
SQL Server 2000 SP2
Analysis Service Sp2

RickYour dll is probably not registered properly. Try to unregister the dll and re-register it. Or download the ado 2.7 version and install it.|||I am running on win2k server, is it safe to use 2.7?
I'm now using MDAC 2.6 SP2 (2.62.7926.1)
thanks~

Rick|||If you feel uncomfortable installing 2.7, I would try unregistering the dll and re-registering. If that does not work, try to reinstall 2.6. One of the sps for sql server may update the dll, so make a note as to which version you are currently using - it may be as simple as an unregistered or corrupted dll.

Good luck.|||Thanks again!
I have use the MDAC Component Checker from the M$ website,
it seems that my version is 2.6 SP2 (2.62.7926.1) and
meets the version in register,

I have unreg and reg the dlls,
but I still got the following components errors:

1. Microsoft ActiveX Data Object (Multi-dimensional)2.6 Library Component
'C:\Program Files\Common Files\System\ado\msadomd.dll'
could not be loaded

2 OLAP Manager Cube Browser
'C:\...\Microsoft Analysis Services\Bin\msmdcb.ocx' could
not be loaded

I'm using SQL2000 Sp2, Analysis Services Sp2, VB 6 SP5
Will it look like a Ananlysis Services problem?

Rick|||Well, your last choices are to try re-install 2.6 and/or installing 2.7. What is the date/time size on these files which are failing ?

Meta Data cleanup

I have a quick question that I could not find the answer for anywhere.
The software developers that provided our SQL database program advised us to
put the subscription expiration on "never expire" because of their past
experience with customers who do not maintain their databases. Because of
this we now how massive meta data tables that need to be purged to increase
replkication performance (synchronization is extrmely slow). I have tried
setting the subscription retention to 14 days, but the amount of data to be
purged is huge and it interferes with the synchroniztion over night.
What I would like to do is use the stored procedure
sp_mergemetadataretentioncleanup to individually clean up the meta data
tables at each subscriber and the publisher. My problem is that I can not
find the parameters and correct syntax for this procedure anywhere. I have
seen the following:
sp_mergemetadataretentioncleanup (?,?,?)
but I don't know what to use to fill the question mark. I'm assuming I need
parameters since it seems doubtful the procedure is complete in itself (I'm
guessing a parameter is retention time and probably database?).
Thanks for the help.
Pete
these are output parameters.
declare @.num_genhistory_rows int , @.num_contents_rows int ,
@.num_tombstone_rows int
exec sp_mergemetadataretentioncleanup @.num_genhistory_rows output,
@.num_contents_rows output, @.num_tombstone_rows output
print @.num_genhistory_rows
print @.num_contents_rows
print @.num_tombstone_rows
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Pete" <Pete@.discussions.microsoft.com> wrote in message
news:C19A9C44-1298-4AC0-8088-57D4ED4DD799@.microsoft.com...
> I have a quick question that I could not find the answer for anywhere.
> The software developers that provided our SQL database program advised us
to
> put the subscription expiration on "never expire" because of their past
> experience with customers who do not maintain their databases. Because of
> this we now how massive meta data tables that need to be purged to
increase
> replkication performance (synchronization is extrmely slow). I have tried
> setting the subscription retention to 14 days, but the amount of data to
be
> purged is huge and it interferes with the synchroniztion over night.
> What I would like to do is use the stored procedure
> sp_mergemetadataretentioncleanup to individually clean up the meta data
> tables at each subscriber and the publisher. My problem is that I can not
> find the parameters and correct syntax for this procedure anywhere. I have
> seen the following:
> sp_mergemetadataretentioncleanup (?,?,?)
> but I don't know what to use to fill the question mark. I'm assuming I
need
> parameters since it seems doubtful the procedure is complete in itself
(I'm
> guessing a parameter is retention time and probably database?).
> Thanks for the help.
> Pete