Errors when trying to run SQL

Ok, whenever I try to connect, I get the following Error messages:

"SQL Server Registration failed because of the connection failure displayed below.
SQL Server does not exist or access denied.
ConnectionOpen (Connect())"

"An Error 1069 occured while performing this service operation on the
MSSQLServer Service"

I even went as far as uninstalling and reinstalling, but to no avail. Does anyone have an idea what's causing this? It was working fine and then all the sudden one day I start getting these messages and it won't work.

Thanks!
SmittyYou using sql server security ot trusted connection?

Do you have a dba, or are you it?

Does anyone else have sa priviliges to the box?|||Thanks for replying Brett...

It's my own personal computer at home so I'm the SA and no one else uses it nor has the ability to. It is the 120-day evaluation edition that I got with the text book that I use for school. I don't understand, it worked fine then it didn't... :confused:

Smitty|||You past the 120 days?

I think it messes with the registry...

You can by a full blown version for $49.00

It just can't be used for production systems...

http://www.microsoft.com/sql/howtobuy/development.asp|||I suppose that's most like the case :( Guess I'll need to buy it sooner or later heh..

Thanks Brett,

Smitty|||If its for study purpose then you can uninstall the SQL and remove all registry keys referred to SQL Server, reboot and reinstall Evaluation edition.|||Thank you Satya,

My instructor told me to do the same. :D

Error:40

I'm using VS2005 Standard Edition with SQL 2000 and get the following error message:

Whenconnecting to SQL Server 2005, this failure may be caused by the factthat under the default settings SQL Server does not allow remoteconnections. (provider: Named Pipes Provider, error: 40 - Could notopen a connection to SQL Server)

I've seen lots of people talking about SQL2005 Express but I'm not even using that version?? I know it gets installed by default when you install VS2005 but I've never used it. I've checked the connection properties to make sure that "using local and remote connections" is checked etc, but still I get the error can any one please help?

Hey,

You can configure that through the SQL Server Surface Area Configuration tool for SQL 2005; I'm assuming that you may be doing something that created the ASPNETDB.mdf file that contains membership/role/profile/other information in it by default... You can tell if you refresh the App_Data folder...

|||Hi,

It did create the ASPNETDB.mdf file and asked me if I wanted to put it somewhere....
I'd been through the surface area tool and made sure that everything is 'enabled' i.e. IP/TCP

I've used sql express before with VWD Express and I never had any problems, but now using a full version of VS2005 it all falls apart! Should I delete the ASPNETDB.mdf file as I'm not using sql express?

This whole problem is driving me up the wall!!|||

Hey,

You don't have to use the ASPNETDB.mdf file, but if you don't use a custom provider, and you access a feature that uses membership/personalization, or if you use the ASP.NET configuration tool, then it will create it for you. Be aware of that...

So you setup under View by Instance > Database Engine> Remote Connections, and made it local and remote connections?

|||Sorry, what program should I be using to do: So you setup under View by Instance > Database Engine> Remote Connections, and made it local and remote connections ?

Many thanks,
James|||Sorry, what program should I be using to do: So you setup under View byInstance > Database Engine> Remote Connections, and made it localand remote connections ?

Many thanks,
James|||Oh, sorry, the SQL Server Surface Area Configuration tool. Then click the first option link (view by ... forget the exact text)|||I have configured as you advised, Remote Connections > Local And Remote Connections
but the sub option I chose was "Using TCP/IP Only", is this correct or should I have chosen the
"Using both TCP/IP and named pipes" option?

Many thanks|||

Hey,

Try TCP/IP only; if that still gives you an error, try named pipes as well. If both don't correct the problem, we know it isn't related to that...

|||I've tried both and it's still the same error.
All I'm trying to do is click on a hyperlink within a gridviewand it passes to another page with a querystring object. The gridview itself populates fine from a remote database which makes me think maybe its something else too!

I'm in the process of migrating an application I created from asp 1.1 (vs2003) to 2.0 (vs2005)
Ihave a datagrid with a hyperlink with a querystring column that whenclicked takes you to another page with parameter "id={0}". However, thedatagrid property builder in vs2003 makes me use three items:
textfield (column name from sql database)
URLField (StudentId - the primary key from sql table)
URLFormatString (updateStudent.aspx?id={0} - this is the page i'm navigating to along with my param)

but in vs2005 the gridview has different options (DataNavigateURL .....etc)
Are you please able to tell me what data needs to go in what property box on the GridView ?

Many thanks
James|||

Hey,

Yeah, DataNavigateUrl is the name of the field that is the ID value in the querystring. DataNavigateUrlFormatString is where you put the page name and the querystring text, such as "otherpage.aspx?id={0}" when the code runs, {0} gets replaced with the value in the field specified by DataNavigateUrl. You can also specify DataTextField to dynamically get the text value and the DataTextFieldFormatString to format that text as well, or just use Text to render static text for the link.

|||

jimmy_fingers:

I'm using VS2005 Standard Edition with SQL 2000 and get the following error message:

When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I've seen lots of people talking about SQL2005 Express but I'm not even using that version?? I know it gets installed by default when you install VS2005 but I've never used it. I've checked the connection properties to make sure that "using local and remote connections" is checked etc, but still I get the error can any one please help?

In Enterprise Manager at the top right click and go to server properties then Network Configurations make sure both TCP/IP and Named Pipes is enabled. Then go to VS2005 at the top click on the Data Link Property to connect. Hope this helps.

|||I appear to have all three properties set up correctly:
DataNavigateUrlField - studentId (primary key for the table in question)
DataNavigateUrlFormatString - updateStudents.aspx?id={0}
DataTextField - StudentName (table column being displayed)

but I'm still getting the same error??|||I'm so very sorry I feel such an idiot!!! I'd made a mistake with my connection string in web.config file.
Although I had done the auto connection I had also hard coded a connection string myself and made a spelling mistake - ROOKIE ERROR! lol

Many thanks though for your help,
James|||

Hey,

No problem. I do it all the time.

error: use trust connect failure -urgent

i use visual studio.net 2003 version and when a progamme run , it told me

do not have trust connect .what is wrong ?how can I do to solute it?

We usually define trusted connection in web.congif like

<appSettings>

<addkey="connectionstring"value="server=localhost;Trusted_Connection=true;database=databaseNamw"/>

</appSettings>

In database users --> Add ServerName\ASPNET account.

That will create trusted connection for the application.

|||

i did as you told me.but it occurs new error as follows:

" database" server of application error.

abnormity particular information: system.data.sqlclient.sqlexception"BUSA_QFDKDIEDKDJ" landing fail.

BUSA_QFDKDIEDKDJ is my server name.

|||

Hi,

I have made little web application to show you how to add user in DB with trusted connection. The DB backup is in the TestDB folder called DB backup. Make Virtual directory and browse it to TestDB folder and Restore backup in MyDB (Create it). Here is link

http://www.riseofkingdoms.com/TestDB.rar

Hope it will work. Change the server name in the string like

<appSettings>

<addkey="connectionstring"value="server=BUSA_QFDKDIEDKDJ;Trusted_Connection=true;database=MyDB"/>

</appSettings>

|||

Hi:

I change the server name ,but it doesn't work. and i am a new proqrammer,and dosen't know much, can you say easily.

|||

i use Query Decomposition to land with trusted connection,and it success.but why

it can't work in the asp.net

|||it occurs the same error.|||

Hi,

You might try checking your SQL Server - make sure you select 'Mixed' security which allows SQL Server login & password to substitute for a trusted connection.

Good luck!

|||

I change the security for 'mixed' security ,but it

occurs error: trusted connection failed.and mayby

sql server's error,because when i use Query Decomposition to land with sa and no password

,bbut it failed .what is wrong?could anyone help?

|||what's wrong ?could anyone help?|||

This problem may be due to the way you have defined your Shared Datasource. Have you stored the login Credentials or used the prompt for login option?

If you used the latter you might want to change to the store credentials option. Hope this helps

|||That's all right.Aftar I select 'Mixed' security ,I didn't restart the computer.