Hello Friends,

After Successful installation of MS SQL Server 2000, when I open my SQL Server Enterprise Manager and expand the node Local (Windows NT), the enterprise manager reports the following error, “A connection could not be established to (LOCAL)”

I don’t know the cause of the error, but sometimes it does not report.

SQL Server Enterprise Manager

A connection could not be established to (LOCAL).

Reason: SQL Server does not exist or access denied.

ConnectionOpen (Connect())..

Hi Friends,

I am facing a problem in creating a Linked Server. I explained my work in steps, for ease to find a solution.

1: Expand Security Node;

2: Right Click Linked Server Node;

3: In General Tab, Provide Name for Linked Server: MYLS;

4: Click Other Data Sources option;

5: Select Provider: Oracle Provider for OLE DB;

6: Product Name: Provide ORCL (Service Name of Oracle that I kept during installation);

7: Data Source: ORCL;

8: Provider String: Provider=MSDAORA.1; Password=tiger; User ID=scott; Data Source=ORCL; Persist Security Info=True;

Hello,

I just encountered this error, while working with MS SQL Server using Cisco Unified CCX and I don't know what  to do at this moment because there is no way at all, to log in the database.

Can someone help? 

This is the error message, 

Failed to login to the database. Ask your administrator to check the database user id and password that is dynamically obtained from the unified CCX server."    

SQL 2008 R2 iso file extraction Error

I download this software from the Internet. Its extension is .ISO. I extracted this software with Magic ISO and now I am trying to install this software but I am receiving the below error.

According to my point of view this file is not properly extracted. Tell me the correct reason and solution.

Microsoft SQL Server 2008 R2 Setup

The following error has occurred:

The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2337.

Hi all,

Please provide me a solution to insert the text which has apostrophe. Example : aaab's.

Messages:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'GH'.

Msg 105, Level 15, State 1, Line 1

Unclosed quotation mark after the character string ')

'.

Thanks in advance.

Grahamamie

Hi,

Hi,

What is normalization? and what is de-normalization?

Explain different levels of normalization.

Can anyone help me understand this?

Regards

Can we get SQL table content results, along with headers?  Say I have a table that has 10 fields of data.

Select * from Patients

I want to copy the content of the results with the headers. Is this possible, I am using SQL 2005?

Microsoft SQL Server error appears again and again. I don’t know how to remove this error. Please give me its solution and also the reason why this error appears, so that next time I can be careful.

I am trying to connect Visual studio to SQL server but it gives error and I can not connect with SQL server. I want to fetch data to SQL but due to this error I can not do my work please tell me how can I get rid from this error.

Microsoft Visual Studio

A network related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (Provider: Named Pipes Provider, error; 40 – Could not open a connection to SQL Server)

OK