Collapse All/Expand All Collapse All
Getting SQL Server Assistance

There are three principal sources of information from Microsoft about SQL Server:

  • The documentation, tutorials, and samples installed with SQL Server.

  • The SQL Server sites on the Microsoft Developer Network (MSDN) and TechNet.

  • SQL Server information on additional Microsoft Web sites.

If you do not find the information you are looking for in these sources, you can either post questions in the SQL Server community forums and newsgroups, or you can open a support case with Microsoft.

When you install SQL Server, you can install the SQL Server documentation (SQL Server Books Online), sample applications, and tutorials. SQL Server Books Online, samples, and tutorials cover the concepts and procedures required to use SQL Server effectively. SQL Server Books Online also includes reference material for the languages and programming interfaces for storing, retrieving, reporting, and modifying data using SQL Server.

If you install the documentation and tutorials by using the SQL Server 2008 Setup program, you can access them in two ways:

  • Through the Documentation and Tutorials submenu on the Microsoft SQL Server 2008 program group.

  • Through F1 Help and Dynamic Help in the SQL Server tools and utilities.

SQL Server 2008 Books Online is also available on the Web. This gives you access to the documentation from a computer on which SQL Server is not installed:

  • A copy of SQL Server 2008 Books Online is published in both the MSDN Library and the TechNet Library. The topics in these copies of the SQL Server Books Online include comments from the community, such as additional information and code examples from other customers. TechNet searches for SQL Server information will return relevant topics from the TechNet Library version of SQL Server 2008 Books Online. All other Web searches for SQL Server  information will return relevant topics from the MSDN Library version of SQL Server 2008 Books Online. You can view the MSDN Library copy at the SQL Server 2008 Books Online Web Page.

  • A downloadable copy of SQL Server 2008 Books Online is available on the Web. You can use the download to install SQL Server Books Online on computers that are not running SQL Server 2008. For more information, see Downloading and Updating Books Online.

Both the download file and the copy of SQL Server  Books Online in the MSDN Library are refreshed when Microsoft publishes an update to SQL Server 2008 Books Online.

For more information about installing and accessing the sample applications and databases, see AdventureWorks Sample Databases.

The Microsoft Developer Network (MSDN) provides online and offline services that help developers write applications using Microsoft products and technologies. The Microsoft TechNet Program delivers comprehensive technical resources that help IT professionals efficiently evaluate, deploy, and support Microsoft solutions.

Several sites on MSDN and TechNet provide a specific audience with links to the SQL Server information most relevant to their jobs, including the information in the copies of the SQL Server Books Online on MSDN or TechNet. These sites also contain information that extends the information available in the Books Online.

The following table describes these resources and their intended audience.

Resource

Audience

SQL Server Developer Center

Developers who are building SQL Server databases, reporting systems, and business intelligence solutions, and enabling their applications and Web sites to use these systems.

Data Access and Storage Developer Center

Developers who are enabling their applications and Web sites to use data stored using products such as SQL Server and Access.

XML Developer Center

Web site creators and application developers whose sites and applications utilize XML for data storage and manipulation.

SQL Server TechNet Site

Administrators and operators who plan, deploy, administer, and support systems that use SQL Server.

Additional SQL Server information is available from these Microsoft Web sites.

Resource

Description

Microsoft SQL Server

Provides pre-sales information about evaluating SQL Server as a data storage and business intelligence tool.

Microsoft Knowledge Base

Provides a searchable repository of SQL Server articles written by Microsoft support.

Microsoft Learning

Describes Microsoft training and certifications for SQL Server.

Microsoft Press

Lists Microsoft Press books about SQL Server.

If you have not found the information you are looking for in the product documentation or on the Web you can ask a question in the SQL Server community forums and newsgroups. You can also request help from product support.

NoteNote

Please do not post questions in the Community Comments section at the bottom of the SQL Server Books Online topics in the MSDN Library or TechNet Library. Those sections are not monitored for questions, and you will usually not receive an answer. Please post questions in the community forums and newsgroups, which are monitored by other customers who can answer your questions.

The following table links to and describes these resources.

Resource

Description

SQL Server IT Professional Community

Has links to newsgroups and forums monitored by the SQL Server community. It also lists community information sources, such as blogs and Web sites. The SQL Server community is very helpful in answering questions, although there is no guarantee of an answer.

SQL Server Developer Center Community

This site focuses on the newsgroups, forums, and other community resources that are useful to SQL Server developers.

Microsoft Help and Support

You can use this Web site to open a support case with a Microsoft support professional.

Microsoft products have a support lifecycle that defines how long support is available for each release. Microsoft support maintains a page that defines the Microsoft support lifecycle. The page contains links to other pages that specify the availability of support for Microsoft products. For more information, see Microsoft Support Lifecycle.


Navigation

 Getting SQL Server Assistance
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Cannot Connect to server on fresh install      rockridder ... steves1102   |   Edit   |   Show History
"I have installed and reinstalled SQL 2008 Server Standard and everytime I try to connect using MS Sql Server Management Studio I recieve the following. 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) (Microsoft SQL Server, Error: 2) I get this error wether I use AD credentials or SA user. Or if I point the (LOCAL) or I spell out the database name. Note that this is on Microsoft Windows server 2008 R2." $0$0 $0 $0Try using the IP address if it is the default instance, or IP address plus the instance name (eg. 192.168.1.1\server1). If the port is not the default port, create an alias for the server and try using the alias to connect.$0 $0Hope this works for you.$0
SQL Server 2008 Developer Edition Installation Error      MVISinc ... Thomas Lee   |   Edit   |   Show History
I am on my second CD and keep getting the same error: "Network error occurred while attempting to read from the file: E:\x86\setup\x86\sqlncli3.msi". This is a standalone installation reading from the CD in my laptop. I returned my original version thinking there was an error in the CD but I get the same error with the new one from Microsoft. I have absolutely no idea what the problem might be. HELP!!!!


[tfl - 16 01 10] Hi - and thanks for your post.You should post questions like this to the Technet Forums at http://forums.microsoft.com/technet or the MS Newsgroups at http://www.microsoft.com/communities/newsgroups/en-us/.  You are much more likely get a quick response using the forums than through the Community Content. For specific help about:
Exchange : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.exchange%2C&;;
SQL Server : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.sqlserver%2C&;;
Windows : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.windows%2C&;;
Windows Server : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.windows.server%2C&;;
Virtual Server : http://groups.google.com/group/microsoft.public.virtualserver/topics?lnk
Full Public : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public%2C&;;

SQL Server Trace      SQL Server Trace ... Thomas Lee   |   Edit   |   Show History
I know that it is possible to create and to replay different traces, by using GUI. I also have scripts for trace, to run from Management Studio, by using T-SQL code. My question is: is there any way to replay trace file, by using T-SQL, NOT GUI?


[tfl - 16 01 10] Hi - and thanks for your post.You should post questions like this to the Technet Forums at http://forums.microsoft.com/technet or the MS Newsgroups at http://www.microsoft.com/communities/newsgroups/en-us/.  You are much more likely get a quick response using the forums than through the Community Content. For specific help about:
Exchange : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.exchange%2C&;;
SQL Server : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.sqlserver%2C&;;
Windows : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.windows%2C&;;
Windows Server : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.windows.server%2C&;;
Virtual Server : http://groups.google.com/group/microsoft.public.virtualserver/topics?lnk
Full Public : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public%2C&;;

Setup Support Rules      Shellybelly1 ... Thomas Lee   |   Edit   |   Show History
I am trying to load SQL Server 2008. I cannot get pass the support rules. Restart computer shows a status of Failed, but when I restart, I come back to the same place with the same failed rule. How can I get pass this?


[tfl - 16 01 10] Hi - and thanks for your post.You should post questions like this to the Technet Forums at http://forums.microsoft.com/technet or the MS Newsgroups at http://www.microsoft.com/communities/newsgroups/en-us/.  You are much more likely get a quick response using the forums than through the Community Content. For specific help about:
Exchange : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.exchange%2C&;;
SQL Server : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.sqlserver%2C&;;
Windows : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.windows%2C&;;
Windows Server : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.windows.server%2C&;;
Virtual Server : http://groups.google.com/group/microsoft.public.virtualserver/topics?lnk
Full Public : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public%2C&;;
Instalation problem...      Tarik2004 ... Thomas Lee   |   Edit   |   Show History

After I install SQL 2008 expres edition .... I have problem to pass trouhg SQL server instalation centar. When I click on Configuration system checker it popsup window wher asking me for Media Source ... I don't know what is asking for ... pleas any help..
I have xp profesional service pack2 ...dual core 2.8 GHz 2Gb RAM.. etc...



[tfl - 16 01 10] Hi - and thanks for your post.You should post questions like this to the Technet Forums at http://forums.microsoft.com/technet or the MS Newsgroups at http://www.microsoft.com/communities/newsgroups/en-us/.  You are much more likely get a quick response using the forums than through the Community Content. For specific help about:
Exchange : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.exchange%2C&;;
SQL Server : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.sqlserver%2C&;;
Windows : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.windows%2C&;;
Windows Server : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public.windows.server%2C&;;
Virtual Server : http://groups.google.com/group/microsoft.public.virtualserver/topics?lnk
Full Public : http://groups.google.com/groups/dir?sel=usenet%3Dmicrosoft.public%2C&;;
Replication from Oracle (as Publisher) to MS SQL 2008      david12345678901234567890   |   Edit   |   Show History
We tried setting up Replication from an Oracle 11g server to our MS SQL 2008 Standard server and we get a message saying we need to have enterprise edition to do this. Is this true? What about if we replicated to MS SQL 2005 standard instead? Any way to buy this capabilitiy without going to enterprise ed? I am trying to get way from using crystal reports with the oracle server but if I cant resolve this then I will probally go this route instead so any help is much appreciated.
Tags What's this?: Add a tag
Flag as ContentBug
Processing
       Send    Community Content  
Click to Rate and Give Feedback
Page view tracker