(local) database wont start?

I dont know how this happened but my (local) SQL Server wont start. I cant access any of the databases. I just get this error:

'A connection could not be established to (local).

Reason: SQL Server does not exist or access denied.
ConnectionOpen (Connect())

Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the (local) node) and try again.'

If I go to check the properties I get the same error. Im completely locked out. I looked at the folder and the database files are there, but I cant get to them through Enterprise Manager.

I have no idea how this problem could have happened. It just seemed to have stopped working. All my other databases can be reached (they are external). Could this be a virus or something? Can someone help me out on this one? I dont have a clue what the problem is, much less how to fix it.

Thanks.Are you CERTAIN that the MSSQLServer service is running? A virus is unlikely the cause.

(different) error logging onto sql server / database help

When trying to connect to my sql server I get the following error :

Connection Failed :
SQLState:'08001'
SQL Server Error : 17
[DBNETLIB][ConnectionOpen(Connect))(.[SQL Server Does not exist or access denied]

im not sure how to give a user access or give the user the right password

I get the same error when trying to create a database and connect to the server.

Im working on xp pro, and using VS.net. also theres a red x next to the cylinder of the sql server, so im assuming im doing something wrong.Check these two things first:
Make sure the authentication method is the same in your pages as the way it's set up on the server

Also - if it's sql/mixed- make sure the login userID and PWD are correct.|||this is the line i have in the web.config file

<identity impersonate="true" userName="MIKE-\Michael"
password="cuomo23"/
how do I check what method is being used on the pages. and the server is which i choose, either windows nt. or sql? correct?|||is mike-\michael a valid user in the SQL database or the Windows Domain? Looks like a local machine account rather than a domain account. So is you web machine the same as the SQL server machine?

"Wrap" replication files

Is there a way to distribute merge and transactional replication commands/files such that a slight hiccup in the connection does not cause replication to fail? Maybe like wrapping them in a zip or other type of file?No, nothing built in, but even if that were the case that won't prevent problems, what if the connection failed during the transfer of the zip file? There's built-in retry logic in the agents for network failures, is this not working correctly for you?|||What do you mean by built-in? Is this supposed to be automatic? Are there settings or distributor properties/parameters I have to set for this? I am not talking about a total loss of connection - just a slight hiccup in communications. Maybe the files could be buffered somehow during the transfer. Is there a way for a custom application to interact with this process?|||distribution agent should retry 10 times before completely stopping, you can increase this interval. For merge agent, since it's scheduled it should just pick up again where it left off on the next sync, or if you're using rmo, you can always check for a disconnect and resubmit a sync.

"Unicode" in Flat File Connection Manager

Hello,

Does anybody know, how to load unicode text file using Flat File Source Task?

I set "unicode" option on the general tab of the Flat File Conn. Manager.

(my text file is comma delimited, the default row delimiter is {CR}{LF})

but on the Column tab I see only one row in one column (I have several rows and columns in the flat file).

How to see them all ?

I appreciate any help !

Anna

Hi Anna,

Do you know if your file is encoded as UTF16 or UTF8. If it is UTF8 uncheck the Unicode flag ans select an appropriate code page for UTF8.

Thanks,

Bob

|||

Hello Bob,

I did it - I set Code page to 65001.

It works now.

Thank you!

Anna

"The underlying connection was closed: An unexpected error occurred on a receive." End

what can cause the above error when connecting to an endpoint via a c# app? the app, and sql are both on my machine ( im just doing this for test purposes and to learn something new.)

i added this code on advice from a web site to the Reference.cs file:

{
HttpWebRequest webRequest = (HttpWebRequest) base.GetWebRequest(uri);

webRequest.KeepAlive = false;
webRequest.ProtocolVersion=HttpVersion.Version10;
return webRequest;
}

Now i get this error.

"The request failed with HTTP status 401: Unauthorized."

this is strange as i have granted the user who the application is running under control access to the endpoint, and even to the function behind the endpoint.

Here is the code behind the button for calling the web service:

private void button1_Click(object sender, EventArgs e)

{

try

{

v_fintag.my_Endpoint wsObject = new v_fintag.my_Endpoint();

wsObject.Credentials = System.Net.CredentialCache.DefaultCredentials;

System.Data.SqlTypes.SqlInt32 sqlint;

sqlint = 25;

System.Data.SqlTypes.SqlString sqlStr;

sqlStr = wsObject.GetFunctionData(sqlint);

}

catch (Exception ET)

{

label2.Text = ET.Message + " : " + ET.Data;

}

}

Also, here is the endpoint, in case its useful or provides information:

create endpoint my_Endpoint

state = started

as http(path='/sql',

authentication=(INTEGRATED),

PORTS=(CLEAR),

SITE='*')

For SOAP

(

webmethod 'GetSprocData'(name='adventureworksdw.dbo.testEndPointSproc'),

webmethod 'GetFunctionData'(name='adventureworksdw.dbo.endpointFunctionTest'),

wsdl=default,

schema=standard,

database ='adventureworksdw',

namespace = 'myNamespace'

)

grant execute on dbo.endpointfunctiontest to [user1]

use master

GRANT CONNECT ON ENDPOINT:: my_Endpoint TO [user1]

"Send Mail Task" Error.

I setup a "Send Mail Task" task and an SMTP connection objection. I ran the package and got this error:

>>>

SSIS package "Package.dtsx" starting.
Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error
message: "Failure sending mail.".
Task failed: Send Mail Task
Warning: 0x80019002 at Package: The Execution method succeeded, but the number of errors raised (1) reached
the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number
specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Package.dtsx" finished: Failure.

>>>

Usually the SSIS error messages are too complicated for me to understand but this one doesn't say enough to be useful. Next, I purposely put in an invaid IP address (last octet = 3456 !) for the SMTP address, ran the package, and got the identical error message. I learned something.

What SSIS tools\logs\strategies can help me track down the problem?

TIA,

Barkingdog

I found the answer. The IS group changed the IP address of the email sevrer and I didn't know it. So...........why didn't SSIS error handling indicate it had trouble connecting to the server or was getting no response or.... something I could work with.

Hopefully, SSIS 2.0 will improve the clarity and quality of error reporting.

Barker

|||

If you have comments to make about future enhancements to SSIS then feed them back to MS via the Feedback Center: http://lab.msdn.microsoft.com/productfeedback/default.aspx

If you don't, you can hardly complain if your requirements are not fulfilled.

-Jamie

|||

Thanks for the Link. I am adding it to my favorites and will submit the request.

Barkingdog

|||

Excellent. I'm a big advocate of the Feedback Center.

-Jamie

"No Such Interface Supported" Exception 0x80004002 - HELP!

AAAAARRRRRRRRRRRGGGGGGGGG!

I finally figure out why I can't connect to the SQLEXPRESS on this computer (technically, I was a remote connection), get everything installed (Advanced edition), and then...

It keeps telling me that "No Such Interface is Supported" and "Unable to cast COM object of type "System._ComObject" to Interface type..."

I grabbed it in a screen capture and will try to get it to a server tonight when I get home.

Any ideas on this problem?

Jason

http://members.cox.net/pamela444/errorwindow.jpg

Well, it won't let me insert a link, but the photo's at that URL.

|||

This error comes from VS. Have you determined if SQL Express is functioning correctly by itself?

On the computer you are getting this error, try connecting to SQL Express using SQLCmd, open a command prompt and type:

SQLCmd -S <machinename>\sqlexpress -Q "select @.@.version"

If this returns the version of your server, then you know that SQL Express is functioning correctly and that you have it configured to accept the connection if you're trying to access it remotely. Info on configuring remote connections is at:

914277 How to configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

"Named Pipes Provider: Could not open a connection to SQL Server [53]", but only on th

My connection string (to a remote instance of SQL Server Exress 2005) is exactly the same when the web files are located on my local machine or my remote machine, and while it works fine when I use the local web files, I get the following error when I use the remote files:

"Named Pipes Provider: Could not open a connection to SQL Server [53]"

As you can see, since it works from the local version, I've setup SQL to accept remote connections via TCP/IP and Named Pipes. I'm using IIS7 on the local, and IIS6 on the remote, in case that makes a difference. I have other sites setup the same way, which work fine.

Any thoughts?

Open the configuration manager and set SQL Server to allow remote connections.
This is off by default on SQL Server Express Edition.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||Thank you for responding, although as you can see in my question, I point out that this is clearly set up, as I am connecting successfully from my local machine.

However, I should note that I have resolved the problem by replicating the database.
|||

Oops, I didn't read that little sentence, sorry :-)

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

"Error in Processing Cubes in Analysis Services"

Hi,

While processing the cube in Analysis server, we are getting frequent error saying

"Analysis Server Error: Connection to the server is lost; Time:2/9/2007 3:56:08 PM
Error(-2147221411): Process operation failed; Time:2/9/2007 3:56:08 PM
Error(-2147221423): Could not open server object (Internal (Database 'PMM' could not be opened on the server)); ". help in this regard will be greatly appreciated.

Thanks,

Umesh

Take a look at the log folder that is located under OLAP folder, right next to the bin folder. It is often installed to C:\Program Files\Microsoft SQL Server\MSSQL.2

If you see multiple SQLDump***.mdmp there. And if you see that after any such processing attempt you see new file is created- this is indication of Analysis Server running into situation it cannot recover from, but abort processing operation.

You should install latest service pack for SQL Server 2005 - currently it is SP1.

After, try running unprocess for entire database and then processing all the objects.

If you still see .mdmp files created, contact customer support and show them the repro schenario for the problem you having.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"could not open connection to SQL Server"?

I just installed a new SQL 2005 Server (September CTP - Developer Edition) on Windows Server 2003 (Using Virtual PC).

I have created a Data Model to be used for creating reports. When I tried to deploy the Model, I got an error along the lines of "...SQL Server does not allow remote connections...".

I then took a step back and tried to browse the report server (http://localhost/reportserver) and I got the message below:

An error has occurred while establishing a connection to the server. 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 also notice that when I go into the Reporting Services Configuration Manager, I see that the Initialization item in the left hand side is Not Configured (has a "red x"). When I try clicking on this item, I get a similar message to the one above.

I am very new at SQL 2005 and this is my first install of it (I have been using other installations in the past). I did some searching and found that I should use the SQL Server Surface Area Configuration utility to allow remote connections for both TCP and Named Pipes. I did this and rebooted my server and I am still getting the same error messages.

Is there something I have yet to configure?

Any and all help is very much appreciated!!!

Thanks!

Brian McCulloughRight after I posted this I realized I renamed the Computer after I installed SQL. The problem was that when I installed reporting services, it created all the connection information based on the "old" computer name.

Brian|||What did you have to do to fix it? Where is the connection information?|||In the Reporting Services Configuration Manager select the Database Setup item on the left-hand side. This is where you specify the Database connection properties for the ReportServer database. I had to change the Server Name to match the current machine name, not what I had it as originally.

-Brian|||I had a similar problem - I was able to fix it by specifying my server as computer-name\servername
Hope this helps

"could not open connection to SQL Server"?

I just installed a new SQL 2005 Server (September CTP - Developer Edition) on Windows Server 2003 (Using Virtual PC).

I have created a Data Model to be used for creating reports. When I tried to deploy the Model, I got an error along the lines of "...SQL Server does not allow remote connections...".

I then took a step back and tried to browse the report server (http://localhost/reportserver) and I got the message below:

An error has occurred while establishing a connection to the server. 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 also notice that when I go into the Reporting Services Configuration Manager, I see that the Initialization item in the left hand side is Not Configured (has a "red x"). When I try clicking on this item, I get a similar message to the one above.

I am very new at SQL 2005 and this is my first install of it (I have been using other installations in the past). I did some searching and found that I should use the SQL Server Surface Area Configuration utility to allow remote connections for both TCP and Named Pipes. I did this and rebooted my server and I am still getting the same error messages.

Is there something I have yet to configure?

Any and all help is very much appreciated!!!

Thanks!

Brian McCulloughRight after I posted this I realized I renamed the Computer after I installed SQL. The problem was that when I installed reporting services, it created all the connection information based on the "old" computer name.

Brian|||What did you have to do to fix it? Where is the connection information?|||In the Reporting Services Configuration Manager select the Database Setup item on the left-hand side. This is where you specify the Database connection properties for the ReportServer database. I had to change the Server Name to match the current machine name, not what I had it as originally.

-Brian|||I had a similar problem - I was able to fix it by specifying my server as computer-name\servername
Hope this helps

"Connect Object Explorer" issue

HI All,

When I connect to a remote database server my IP gets stored in the Object Explorer connection wizard. How do u ensure that once the server is disconnected you have to reenter the server IP again.

It also shows the username as soon as i enter the server name. I don't want this to happen. Please help.

A SQL Server MVP had the same question not too long ago. We found him an answer and he posted it on this blog:
http://devcow.com:80/blogs/adnrg/archive/2006/09/08/Clear_SQL_Server_2005_Management_Studio_recent_servers_drop_down_list.aspx

Basically, there is no way to clear it out through the UI. You have to delete the following file:
C:\Documents and Settings\<user>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

"Can't find PInvoke DLL 'dbnetlib.dll'."

every time when I opened the connection from my windows CE4.2 device to sql server I got the error "Can't find PInvoke DLL 'dbnetlib.dll'.

My OS is MS CE4.2, I've installed Compact Framework 2.0 and SQL client. It worked fine at OS CE5.0 but not at CE4.2. My application is working correctly, but when I started the connection I received this error.

Any idea?

thanks, Jan

If you indeed have SQL Client installed properly, I would guess some dependencies required for it to function are missing from the OS image. Contact device OEM for help.

<<< Connection Problem with SQL Server + C#.Net on Local Area Network >>>

hi all,
i m new on Sql and i have a project related to C# and Sql.
i have to do a project which must work on LAN, and there must be only
one database file on main computer(Server Computer) and other
computers(client computers) must connect database on main computer.
i m preparing my project on my personal computer(it is called MYCOMP)
and doing connection with wizard. then it doesnt work on other
computers(works only my personal computer). when i done connection with
wizard .Net create a connection code like below...
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=MYCOMP;packet
size=4096;integrated security=SSPI;data source=MYCOM" +
"P;persist security info=False;initial catalog=migros";
i think, because of taking my computer's name in connection string it
doesnt work on other computers...
what can i do for this problem :((((((((
please write me a solution as soon as possible...( i have only 15 days
to hand over and still couldnt start to write my codes, otherwise i
cant graduate...)
PLEASE HEEEEEEEEEEEEEEEELP !!!!!!!
thnks for now.....Hi, no need to multipost.
Answered in .programming.
HTH, jens Suessmeyer.
--
http://www.sqlserver2005.de
--