problem in ConnectionString

hi,
i have problem in connectionstring in sql server.
my connection string is,
--
conn.ConnectionString = "workstation id=BARODA;packet size=4096;integrated security=SSPI;data source=BARODA\MYINSTANCE;user id=sa;password=;persist security info=True;initial catalog=SMS"
it will give error like....
login fail for user "MERIDIAN\IUSER_GROUP"

---
conn.ConnectionString = "workstation id=BARODA;packet size=4096;data source=BARODA\MYINSTANCE;user id=sa;password=;persist security info=True;initial catalog=SMS"
it will give error like....
login fail for user "sa"

---
conn.ConnectionString = "workstation id=BARODA;packet size=4096;data source=BARODA\MYINSTANCE;user id=;password=;persist security info=True;initial catalog=SMS"
it will give error like....
login fail for user "(null)"

i can do everything, but error occur everytimes.

when i use this, without instance
conn.ConnectionString = "workstation id=BARODA;packet size=4096;data source=BARODA;user id=;password=;persist security info=True;initial catalog=SMS"
it will run successfully,

but i have instance,
and i want to run with it.

plz give any idea.
it's urgent.

thanks in advance.check www.connectionstrings.com

hth|||i also check this site. but error occurs as it is.
my sql server in mix mode auth.
i also create MERIDIAN\IUSR_BARODA,inspite of this error comes.
i do everythings.

----login fail-'MERIDIAN\IUSR_BARODA'
conn.connectionString="workstation id=BARODA;packet size=4096;integrated security=SSPI;data source="BARODA\MYINSTANCE";persist security info=True;initial catalog=SMS"

----login fail-'sa'
conn.ConnectionString = "data source=BARODA\MYINSTANCE;user id=sa;password=;initial catalog=SMS;persist security info=true;workstation id=BARODA;Packet size=4096"

----login fail-'null'-not associated with trusted connection
conn.ConnectionString = "data source=BARODA\MYINSTANCE;initial catalog=SMS;persist security info=yes"

----login fail-'sa'
conn.ConnectionString = "workstation id=BARODA;packet size=4096;data source=BARODA\MYINSTANCE;user id=sa;password=;initial catalog=SMS"

----login fail-'MERIDIAN\IUSR_BARODA'
conn.ConnectionString = "workstation id=BARODA;packet size=4096;integrated security=SSPI;data source=BARODA\MYINSTANCE;user id=sa;password=XX;initial catalog=SMS"

----login fail-'sa'
conn.ConnectionString = "workstation id=BARODA;packet size=4096;integrated security=false;data source=BARODA\MYINSTANCE;user id=sa;password=;initial catalog=SMS;persist security info=false"

----login fail-'sa'
conn.ConnectionString = "data source=BARODA\MYINSTANCE;user id=sa;password=;initial catalog=SMS;trusted_connection=false"

connectionstrings which is given above i was use it but above error occurs.

plz give any idea.
it's urgent.

thanks in advance.|||you need to add the machinename\ASPNET user account to the users for your database in the enterprise manager. the connection string is correct. the user does not seem to have access to the db.

hth

problem in connectionstring

when I write this code in web.config :

<configuration><appsettings><addkey="constring" VALUE="WORKSTATION id=I-85096B7FC8F64;packet catalog='test"/' info="True;initial" security="SSPI;data" source="I-85096B7FC8F64;persist" size="4096;integrated"><system.web>

and write this statements in the code of program :

string Constring = ConfigurationSettings.AppSettings("constring"); SqlConnection conn = new SqlConnection(constring);

this error is displyed:

The name 'constring' does not exist in the class or namespace 'C_sharp1.WebForm1'

In C#, instead of:
ConfigurationSettings.AppSettings("constring")
use square brackets:
ConfigurationSettings.AppSettings["constring"]|||

thanks a lot.

the problem is solved by your solution.

problem deploying report - can't connect to server?

Hello,
I am relatively new to reporting services. I was experimenting with some
already developed reports on a workstation and trying to figure out how
things work. The reports run fine, and I can deploy them from the solution
folder where the reports exist.
Then I tried creating my own report in my own solution folder. I was able
to create a basic report with a paramenter and run it in the IDE. But when I
tried to deploy it, I got an error message that the service could not connect
to the server. Is this like asp/aspx where you need a virtual directory or
something like that in IIS? What do I need to do to deploy my test report
from my new solution folder?
Thanks,
RichOK. I figured out how to deploy my report. I had to go to the solution
explorer, right-clicked on the ReportProject name, selected properties and
entered the name of the server machine where ReportServer resides. My report
successfully deployed.
But how can I access my report on the company intranet? Any suggestions
appreciated.
"Rich" wrote:
> Hello,
> I am relatively new to reporting services. I was experimenting with some
> already developed reports on a workstation and trying to figure out how
> things work. The reports run fine, and I can deploy them from the solution
> folder where the reports exist.
> Then I tried creating my own report in my own solution folder. I was able
> to create a basic report with a paramenter and run it in the IDE. But when I
> tried to deploy it, I got an error message that the service could not connect
> to the server. Is this like asp/aspx where you need a virtual directory or
> something like that in IIS? What do I need to do to deploy my test report
> from my new solution folder?
> Thanks,
> Rich|||OK. Figured this one out also. For posterity I share what I did. I went
back to the solution explorer and right-clicked on the Project Name, selected
properties. In the same dialog where I had to change the server name from
localhost to my server's name, apparently, by default, the startItem is set
to Report1.rdl. My report's name was RptTest1.rdl. The startItem has a
dropdown box where RptTest1.rdl was listed, so I selected it. Then I
re-deployed my report and viola! It showed up on IE along with the parameter
box. It ran fine. Yay!
"Rich" wrote:
> OK. I figured out how to deploy my report. I had to go to the solution
> explorer, right-clicked on the ReportProject name, selected properties and
> entered the name of the server machine where ReportServer resides. My report
> successfully deployed.
> But how can I access my report on the company intranet? Any suggestions
> appreciated.
>
> "Rich" wrote:
> > Hello,
> >
> > I am relatively new to reporting services. I was experimenting with some
> > already developed reports on a workstation and trying to figure out how
> > things work. The reports run fine, and I can deploy them from the solution
> > folder where the reports exist.
> >
> > Then I tried creating my own report in my own solution folder. I was able
> > to create a basic report with a paramenter and run it in the IDE. But when I
> > tried to deploy it, I got an error message that the service could not connect
> > to the server. Is this like asp/aspx where you need a virtual directory or
> > something like that in IIS? What do I need to do to deploy my test report
> > from my new solution folder?
> >
> > Thanks,
> > Rich