The MS SQL Server is a database management relational database created by Microsoft in partnership with Sybase in 1988 and inserted as a complementary product to Windows NT. Tag questions specific to a version with [sql-server-2012], [sql-server-2008], etc.

learn more… | top users | synonyms

2
votes
0answers
291 views

Access losing db connections

I have a weird problem going on at work. People have been using MS Access to connect to SQL Server db and lately people are getting sporadic problems with connecting to the servers. It's not always ...
1
vote
2answers
3k views

Problem creating ODBC connection to SQL Server 2008 with Vista

Well, I'm trying to get a database schema thing working, first I tried just doing it in Linux where I'm more comfortable, but ODBC seems to be a hack there and I couldn't get it to work. So I figured ...
3
votes
3answers
4k views

Archive Outlook mail items into SQL Server

I am looking (and so far not finding any) for a solution to archive e-mail items from my Outlook into SQL Server. My PST is beginning to get really really big, and I'd love to extract my older e-mail ...
0
votes
2answers
114 views

SQL Server on Linux

For a particular project that is coming up, I am trying to expand my knowledge of Linux, so I am going to set up a Linux system at home. Rather than dual booting, I am thinking about putting SQL ...
2
votes
3answers
1k views

Why does MS SQL Server Management Studio almost freeze up my computer while it restores?

Why does MS SQL Server Management Studio almost freeze up my computer while it restores? It makes it so when I click on the clock it takes seconds for the calendar to open. I don't see why this ...
1
vote
3answers
2k views

How to connect to a SQL server through a public IIS server

I have two computers on my LAN. One with IIS and a public IP, the other with SQL Server and a LAN IP. How I can access to the SQL server through the IIS server from a computer connected to the ...
0
votes
1answer
666 views

is using Hosts for resolving a sql-server more performant?

we have a legacy application which uses a access.mdb with hundreds of ODBC-connected tables on a sql-server. the access.mdb contains nothing else than these odbc-connections. Now we consider to use a ...
3
votes
2answers
2k views

How can I start using MS-SQL Server ( express )

I have just installed Microsoft SQL Express from here: http://www.microsoft.com/Sqlserver/2005/en/us/express-down.aspx I need it because an example of some code I have uses it. How do I start using ...
3
votes
1answer
2k views

I can't “unmaximize” my window

I've got a windows app (I don't think it matters which one, but in case you're wondering, it's SQL Server Profiler) that I can't put back into "windowed" mode. I can maximize or minimize it, either ...
3
votes
3answers
1k views

Is my system compromised? I got message about ntoskrnl.exe

I am not sure this question belongs her or not but let me try. When I get to office this morning One of my colligues had a problem with his laptop and told me he had trouble restarting it and when he ...
23
votes
10answers
90k views

How do I open SQL Server Management Studio?

How do I open SQL Server Management Studio? I installed it but I don't see where I can open it.
0
votes
1answer
302 views

How to find sql server instance?

I have sql server 2000 and 2005 installed on my machine. Now instances were installed as Machine04 [2000] and other Machine04\SomeInstance [2005] (this some instance i don't remember now) So is ...
0
votes
1answer
217 views

SQL Server 2000 Client won't connect

One day instead of connecting to the database my SQL Server Management gave me the following error: "Data Source name not found & no default driver found" Note it had been working for several ...
1
vote
3answers
2k views

Connecting from Mac OS X 10.6 to MS SQLServer

I develop iPhone Apps so my set up is a Mac running Snow Leopard (10.6). However the databases that the App connects to all run SQL Server (2005 or 2008). I would like a native (free?) solution to ...
3
votes
3answers
3k views

Creating a named pipe on Windows

I want to write a large dataset from a SQL Server 2005 database using BCP (bulk copy program). Ideally I'd like to do the following: bcp MyDatabase..MyTable OUT STDOUT -c -t, |gzip -c ...
0
votes
1answer
66 views

Password format not liked by installer

I'm installing Chargeback and I get to the database-related information page (step 5 on page 17 of the users guide). Using a Windows account (it is an administrator of the server and I am logged on ...
2
votes
3answers
887 views

WIndows XP file path in Windows Vista?

I am looking for a SQL Server file I am supposed to delete, only the instructions I found for this are for Windows XP and my OS is Windows Vista. And as ridiculous as this is, I cannot find this file ...
1
vote
2answers
2k views

Start an SQL Server instance without SQL Server Management Studio

I took my SQL Server 2008 offline because I was trying to do something... Now I can't log in to it using SQL Server Management Studio anymore. "The server was not found or was not accessible." I'm not ...
1
vote
4answers
4k views

Copy a SQL Server 2008 database verbatim

I need to copy my entire SQL Server 2008 database including the schema and all data verbatim from one computer to another. How do I do that?
3
votes
2answers
12k views

How do I give myself admin rights to a sql server instance, having forgotten the sa password?

I have lost all passwords for a SQL Server instance, how do I give myself admin access again?
0
votes
2answers
2k views

Registry entry for Microsoft SQL Server

How can I check from the registry which Microsoft SQL Server(2000,2005 or 2008) is installed in my computer?
0
votes
4answers
11k views

How to obtain the Windows product id from registry from a remote machine

Would like some assistance on how to obtain the Windows product id from the registry that will work where the WIndows (Windows 2003 Server, 2008 Server) is on a Domain or Workgroup and a remote ...
1
vote
1answer
3k views

Problem with logging into SQL Server Management Studio

I can log into SQL Server Management Studio with a SQL Server Authentication login and password, but when trying to log in with Windows Authentication I get this error: "Cannot generate SSPI context. ...
0
votes
1answer
333 views

Opening offline version of Microsoft Books Online in browser

I often use the MSDN website for language reference. In order to make navigation faster, I downloaded the offline version of SQL Server 2005 Books Online from here: ...
0
votes
3answers
256 views

How can I know about the local SQL Server on my system ( windows 7 )

How do I know whether I have a local SQL Server on my system? If there is what are the login details to the local SQL Server ? I have a windows 7.
1
vote
1answer
653 views

Linux ODBC database driver for MS SQL Server?

Where can I get an ODBC database driver for MS SQL Server? I need to publish data from a perl script in Linux to an MS SQL Server.
1
vote
2answers
1k views

Can I install Sql Server 2008 on my windows home server

I would like to do more with my Windows Home server than file sharing and backups. Has anyone tried installing SQL Server 2008 (any version, but I'm using Professional) on a Windows Home Server?
6
votes
5answers
20k views

Rule “Restart computer” failed when installing SQL Server 2008

When trying to install SQL Server 2008 Developer and Enterprise editions on a Windows 7 box I've got this message: Rule "Restart computer" failed. A computer restart is required. You must ...
1
vote
1answer
197 views

How do I find out what my SQL Server database audit records contain?

I need to find out if my SQL Server 2005 database audit records contain the required information that I need. Where or how can I find this out?
1
vote
1answer
635 views

What do these Microsoft Updates do, and why can't they configure correctly?

MB: Biostar M7NCG 400 CPU: AMD Athlon XP 2200+ 1.8GHz RAM: 2.5GB (I don't know the speed, but does it really matter?) Display: NVidia GeForce 4 TI 4200, with hardware support for ...
2
votes
1answer
450 views

How can I add a keyboard shortcut for Find-In-Files in SQL Server Management Studio?

I'd like to make it Ctrl-Shift-F to match Visual Studio. I realize to do that I need to remove that binding from the Query->Save to File item. But, I can't even add ANY shortcut. When I pull up the ...
1
vote
1answer
2k views

Why Can't SQL Server Management Studio Access The “My Documents” Folder in Windows 7?

I have a database backup located in my Windows 7 Documents folder (C:\Users\Aaron\Documents...), and I'm trying to restore it using SQL Server Management Studio. However, the program is unable to ...
0
votes
1answer
2k views

How to backup Windows 7 Live Photo Gallery?

How do I backup Windows Live Photo Gallery? I've been running on Windows 7 RC and I want to upgrade to the full Windows 7 release. I've been managing my photos with Live Photo Gallery. I want to ...
4
votes
2answers
151 views

How do I connect to a SQL Server DB to run some queries?

I have a SQL Server DB but have no idea how to connect to it to run some queries. I naively assumed that I'd be able to open up a DB in a similar fashion to Microsoft Access, but can't seem to do ...
1
vote
3answers
489 views

Is there a way to restrict direct write access to the database in Microsoft Access 2007?

I'd like to set up an Access (2007) project that contains queries on a database (actually in MS SQL Server 2005), but I don't want to allow any direct writing to the database. How can I make it ...
1
vote
2answers
2k views

SQL Server Linux admin tools

I would like to know if there is sql server tools for linux? eg. tools like sql server enterprise manager.
0
votes
2answers
498 views

What does the term CXPACKET stand for?

Google does not appear to have a definition of the term.
1
vote
1answer
99 views

What registry entries does SQL 2005 rely on, and which information does it store in them?

I am looking for an exhaustive list of registry entries that are only used by SQL Server 2005, and documentation on what they are used for.
1
vote
2answers
372 views

Trouble logging into SQL Server

Getting error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Restarted the service, server, and all the computers in between. I suspect it's not ...
10
votes
3answers
21k views

Which ports to open for Microsoft SQL Server?

Having searched the internet a few times on the best way to open up SQL Server connectivity through windows firewall i've yet to find a best way of doing it. Does anyone have a guaranteed way of ...
0
votes
4answers
18k views

Run as administrator needed for IE8 workaround but user is in Administrators group

I'm running IE8 on Windows 7 and logging in under a company domain account (not the machine domain). The domain account is assigned to the machine's administrators group. As a workaround for the issue ...
2
votes
1answer
2k views

Can I delete files in the 'C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG' folder?

This is on my development machine, running Windows XP, and I don't run any production db's on it.
3
votes
1answer
2k views

SQL Server Connectivity Test

Many times people around me fail to connect to SQL Server from other Non-Microsoft Applications. Assuming that there is no SQL Server Client installed, what are the different ways we can ...
2
votes
3answers
4k views

Why won't Windows 7 install my downloaded .NET 3.5 SP1?

When I try and install SQL Server 2008 Developer Edition, it stops and says I need .NET 3.5 SP1. Windows 7 has .NET 3.5 installed (I selected it in features) but I guess it's not SP1? (I'm running ...
4
votes
11answers
6k views

Less daunting front end for SQL Server

We currently have a few users who have been using Access very succesfully to throw around large amounts of data. We've now got to the point where the data is just too large to be held in Access, as ...
8
votes
9answers
19k views

Why does it take so long for SQL Management Studio to connect?

Considering that Microsoft SQL Server is not, technically, a slow database management system, I keep wondering why it often/usually takes such a long time for SQL Management Studio to connect. This ...