Managed Store Procedure does not deploy

I have created a managed stored procdure in a sql server project in VS. I have put in the corect server name password and login fro the connection to the database.

When I deploy however it doesn't deploy the stored proccdure to the database even though it says it has successfully deployed the stored procedure. Has anyone had this

problem and how can you make sure it is deploying to the correct database.

Did you make sure it is deploying the stored procedure into the correct database? It might be deploying it in master.mdf.

sql

Making SQL 2005 Developer accept the connection string for SQL express edition

Hi, I have installed on my laptop SQL server 2005 Developer edition, I can change ANY of the settings of the SQL server and OS.

I am writing code with a team using continuous integration where the connection string is the following:
"Provider=SQLNCLI;Server=.\SQLEXPRESS;Database=Secret;Trusted_Connection=Yes;"

is there a way (create an alias,rename server, other?) to make my local dev SQL server accept the connection string above, as at the moment I have to rename the connection string every time before checking in code and after downloading the latest version from the code repository.

any advice or tips will be greatly appreciated

Thanks

JW.Hi,

setup an alias using the SQL Server Configuration manager. Configure a new alias to listen to .\sqlexpress and redirect to the installed dev server.

HTH; Jens K. Suessmeyer.

http://www.sqlserver2005.de

Making replication more reliable

We have about 90 sites doing merge replication with pull subscriptions over
a DSL VPN.
Replication often stalls following a dropped connection. Normally,
restarting SQL Server Agent at the subsciber gets things moving again.
Any good suggestions on a way to a perform this restart. We can't really do
it from within our user application as they don't have sufficient privilege.
Any easy way to do it from the publisher site?
Also are we making things worse for ourselves by running the merge agent
continuously?
Tony Toker
Data Identic Ltd.
either schedule your agents to run every 10 minutes, or set up your job so
that on job failure it wraps around and starts job step 1 again.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Tony Toker" <xyzzy@.identic.co.uk> wrote in message
news:cgi1vo$p1d$1$830fa795@.news.demon.co.uk...
> We have about 90 sites doing merge replication with pull subscriptions
over
> a DSL VPN.
> Replication often stalls following a dropped connection. Normally,
> restarting SQL Server Agent at the subsciber gets things moving again.
> Any good suggestions on a way to a perform this restart. We can't really
do
> it from within our user application as they don't have sufficient
privilege.
> Any easy way to do it from the publisher site?
> Also are we making things worse for ourselves by running the merge agent
> continuously?
> Tony Toker
> Data Identic Ltd.
>
|||Thanks for the tip.
Some of the agents don't actually fail, but run indefinitely.
I'll look at checking connectivity then running replmerge, or the activex
controls (which aren't currently deployed) from our application to synch
when necessary.
This will be a stupid question whatever the answer but would replmerge work
with a push subscription, ie can you initiate synchronization of a push
subscription at the subscriber?
Thanks for all your help on here, you need to get that book out and start
earning for your advice!
Tony
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:uZzHfRqiEHA.3428@.TK2MSFTNGP11.phx.gbl...
> either schedule your agents to run every 10 minutes, or set up your job so
> that on job failure it wraps around and starts job step 1 again.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Tony Toker" <xyzzy@.identic.co.uk> wrote in message
> news:cgi1vo$p1d$1$830fa795@.news.demon.co.uk...
> over
> do
> privilege.
>

Making a connection to a sql server via webmatrix

Hi all,
i'm making a webpage via the walkthrough of webmatrix. I use the tutorial 'Build an End-to-End Application (with C#.NET) '. The problem is that this tutorial works with an access db. I'll try to start the same thing but using an sql server.

Nowhere i can't find (because i don't look at the right place i gess) how i have to make a sqlconnection via webmatrix with c# using a keyfield to filter my data and to fill out a datagrid.

can somebody help me please ?

thnxWell, there are examples using MSDE at the same site (ASP.NET Web Matrix Project Guided Tour), so maybe you could piece it together.

The approach should be very similar -- generally you use the "Sql" prefix everywhere instead of "Oledb", and the connection string would need to be updated.

Terri|||Thnx Terri for your reply. Like you can gess i never done anything with asp or c#. I always worked with vfp and sqlserver.

Kurt|||Once you've got more of the code together, let us know if you are still having problems. We should be able to help fill in the gaps. (Although theData Access forum will probably be a better place to post since it's an ADO.Net topic.)

Terri

makepipe and readpipe on cluster

I am trying to see if named pipes connection works on my cluster, sql server
2K.
I have tryied the 2 utilities, makepipe and readpipe.
The connection works if, when using readpipe, I use the physical server name.
But our configuration is on MSCS 2 nodes Cluster.
If I use the virtual name the connection fails.
Is that normal?
Please advise.
Franco
Did you have any problem connecting to a SQL instance in the cluster via
named pipes? If so, why not just use osql to test your named pipe
connectivity.
Linchi
"Franco" wrote:

> I am trying to see if named pipes connection works on my cluster, sql server
> 2K.
> I have tryied the 2 utilities, makepipe and readpipe.
> The connection works if, when using readpipe, I use the physical server name.
> But our configuration is on MSCS 2 nodes Cluster.
> If I use the virtual name the connection fails.
> Is that normal?
> Please advise.
> Franco

Make Connection to SOAP endpoint without integrated login?

I have a endpoint on our SQL Server and I've written a test .Net app to access it and it all works great. It uses the Integrated Login for Authentication.

My project in the end will have connections made to the endpoint via some custom code on a Non Windows/Linux platform. My concern is that there is no Authentication method that I can use from this client. Integrated is out since it not something you log into. SSL is out since there is no Cert store. Isn't there a way to use the SQL Authentication in a Mixed mode SQL Authentication install?

What are my other options? I need to be able to get data from our SQL server from this custom platform. We looked into using TDS protocol, but would rather not have to license it and develop a client on our platform. We wanted to just generate the HTTP Packets to send and receive the data.

Thank you,

Scott<-

SQL SOAP always requires integrated login first before you can use SQL login. You should try digest it should work from a non-MS platform.

Major Problem!...Multiple user connection problem in reporting service 2000 with SOAP

Hi Everyone,

I am having a big problem here.

I am using Reporting Service 2000 and Visual Studio 2005. I have developed a custom web control which communicates with reporting web service and displays report. I pass username, password and domain information as network credential for communicating with report server (report server is remote). This is a web application in which users can see reports on the web page which uses my custom web control.

Everything works fine when there is single user. But when another user logs onto website and tries to access same or different report it seems like connection of the first user gets lost. And everything crashes for first user and for second user it works fine.

In fact if second user is accessing the same report then first user can see second user's report information which is no at all acceptable. I am sure that there should be some way so that multiple users can communicate with reporting server programmatically at the same time. Microsoft wouldn't make reporting web service so that only one user can access report at a time, would they?

Can anyone help me with this problem? Any help will be greatly appreciated.

Sounds like your users are being identified as the same person which would suggest annonymous access is being used or your web control is passing the same credentials for both users. I'm not sure how you've coded it or whether you are doing any caching or storing session state somewhere.

You have to narrow down what is at fault here. I would suggest the following:

Set your report server and report manager virtual directories to integrated or basic authentication and have 2 separate users access report manager at the same time|||

Thanks Adam for quick reply.

I don't have anonymous access enabled. I am using integrated windows authentication. Earlier i was trying to authenticate all users with one administartor credentials to communicate with Reporting web service. But then i changed my code so that it takes individual user's credentials. But this didn't make any difference.

I read in one reporting service book that Report server overwrites SessionID member after each call to the Render method. Therefore, two subsequent report requests will share same sessions only if they ask for the same report (assuming that the parameter set is same)

For example, let's say you run report A, then report B, and then report A again. When report B is rendered, its session identifier will overwrite the previous session identifier, which means that you will lose report A's session identifier. When report A is run again, even if the parameter set is the same, its execution will create a new report session and IsNewExecution will return true.

So i think this overwriting of SessionID by report server is causing the problem. But i don't know yet how to program so that it maintains proper SessionID for each user and hence doesn't crash for any user.

If anyone has any idea for solving this problem then please let me know. Thanks in advance.

|||Figured out. It was bug in my code. Accidentlly i had declared Parameter property as static in my code and because of that one user's report was using other user's property and which was making program crash. Thanks for reply though.

Major Problem - Please Help!

Hello Experts,
When I Open Enterprise Manager and click on my server,
following msg appears:
SQL Server Enterprise Manager
----
A Connection could not be established to (LOCAL).
Reason: Data source name not found and no default driver
specified.
Please Verify SQL Server is running...bla, bla.
----
What Cause this:
1) I have Windows XP with SP1
2) I have had installed MDAC 2.8
3) I uninstall MDAC 2.8 using "dasetup.exe /U" command,
setup found that MDAC 2.6 is referenced to MDAC 2.8 an
had to uninstall this too, I pressed OK and then the
uninstall failed because the default of Windows XP MDAC
is 2.7 SP1 and setup propably found that some other MDAC
had to be the default.
Any way, I ReInstall MDAC 2.6 (Latest), MDAC 2.7 Refresh
and Q323263_MDAC27_x86_en.
What do I have to do having as default "MDAC 2.7 SP1 on
Windows XP SP1" and ODBC Drivers work?
Thanks in advance.Make sure shared memory is enabled in client network utility (start | run |
cliconfg)
Try editing the registration property for the server in Enterprise Manager
(Right click on the server and choose to edit registration properties). Use
the server name instead of (local)
Thanks
Deepali
This posting is provided "AS IS" with no warranties, and confers no rights|||Thanks for your response, I will do that and let you know.

>--Original Message--
>Make sure shared memory is enabled in client network
utility (start | run |
>cliconfg)
>Try editing the registration property for the server in
Enterprise Manager
>(Right click on the server and choose to edit
registration properties). Use
>the server name instead of (local)
>Thanks
>Deepali
>This posting is provided "AS IS" with no warranties, and
confers no rights
>.
>

Major Multiple connection problem RS2000 with SOAP

Hi Everyone,

I am having a big problem here.

I am using Reporting Service 2000 and Visual Studio 2005. I have developed a custom web control which communicates with reporting web service and displays report. I pass username, password and domain information as network credential for communicating with report server (report server is remote). This is a web application in which users can see reports on the web page which uses my custom web control.

Everything works fine when there is single user. But when another user logs onto website and tries to access same or different report it seems like connection of the first user gets lost. And everything crashes for first user and for second user it works fine.

In fact if second user is accessing the same report then first user can see second user's report information which is no at all acceptable. I am sure that should be some way so that multiple users can communicate with reporting server programmatically at the same time. Microsoft wouldn't make reporting web service so that only one user can access report at a time, would they?

Can anyone help me with this problem? ANyhelp will be greatly appreciated.

I don't have anonymous access enabled. I am using integrated windows authentication. Earlier i was trying to authenticate all users with one administartor credentials to communicate with Reporting web service. But then i changed my code so that it takes individual user's credentials. But this didn't make any difference.

I read in one reporting service book that Report server overwrites SessionID member after each call to the Render method. Therefore, two subsequent report requests will share same sessions only if they ask for the same report (assuming that the parameter set is same)

For example, let's say you run report A, then report B, and then report A again. When report B is rendered, its session identifier will overwrite the previous session identifier, which means that you will lose report A's session identifier. When report A is run again, even if the parameter set is the same, its execution will create a new report session and IsNewExecution will return true.

So i think this overwriting of SessionID by report server is causing the problem. But i don't know yet how to program so that it maintains proper SessionID for each user and hence doesn't crash for any user.

If anyone has any idea for solving this problem then please let me know. Thanks in advance.