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

1
vote
2answers
20k views

How to install MS sql server client in 64 bit windows 7 operating system?

I want to install sql server client in my windows 7 64 bit version. But I am unable to do that please provide some help. i want to install only Client not sql server. is this possible.
1
vote
2answers
3k views

Can't access SQL Server from outside the network

I am trying to log in remotely to SQL Server 2008 R2. After reading several posts I was able to log in remotely from a computer on the same network. But I still cannot remotely log in from outside ...
1
vote
1answer
873 views

Open port for Microsoft SQL database connection from outside the Windows7 computer

My Firewall seems to be blocking the connection from anywhere to my local MS Sql Server on my Windows7 development machine. On Linux and Mysql I could telnet the database ports and it gives response ...
0
votes
1answer
2k views

Custom forms in Sharepoint with MS SQL Server as Backend. Is it possible?

We're evaluating using SharePoint 2010 as our project management tool. Specifically, the system needs to satisfy the following: Discussion groups Project management (simple issue tracking, no ...
1
vote
2answers
2k views

How can I make a usable copy of an SQL Server database on Windows Server 2003?

I need to make a usable copy of an SQL Server database on Windows Server 2003 for testing purposes. There is a backup tool built into Enterprise Manager but I can't seem to make it work. I've tried ...
2
votes
1answer
4k views

How can i compress when I create SQL backup file in a folder?

I use SQL Server Express and I create backup files for all databases every day using Time Scheduling script. One script Like that; BACKUP DATABASE [Jira] TO DISK = N'C:\Backup\Jira.bak' WITH ...
2
votes
3answers
3k views

SQL Server Ports

The Microsoft website states The firewall must be configured to permit port 1433 incoming (or the port numbers that SQL Server listens to on TCP/IP), and ports 1024 to 65535 outgoing. Does this ...
1
vote
1answer
227 views

SQLCMD -L option with a smaller timeout

I am trying to use the sqlcmd -L c command to find out the instance name of the SQL server running on the local machine. It succeeds, but I have to wait for a full minute, for the tool to realize that ...
3
votes
1answer
624 views

Purging Expired SQL Server Backups

I have set up a SQL Server Agent job to execute a backup every night at 3am. The job appends the backup to an existing backup file, and sets the expiry of the backup to expire in 7 days time. It's ...
3
votes
3answers
22k views

How to remove a broken installation of SQL Server 2008?

After installing the Service Pack 2 of Microsoft SQL Server 2008, the SQL Server failed to start. Trying to repair this, I've done some stupid things, which results now in the situation in which I ...
2
votes
1answer
669 views

How to convert Microsoft sql 7 database to Microsoft sql 2008 database?

Is it possible to convert an Microsoft SQL 7 database into Microsoft SQL 2008?
6
votes
2answers
2k views

preserving \n from SQL Server Management Studio

I have a column called EventLog varchar(max) and can be pretty big because essentially it stores the event log of an entire batch process. The problem is that when I go into the query window and do ...
4
votes
4answers
8k views

Cannot connect with Sql Server Studio: error 18456, state 8 — but password is correct!

Using Sql Studio Express (on a Windows 7-64 machine) to connect to three different Sql Server 2005 servers using Sql Server Authentication, I'm getting Error: 1846, State: 8. According to ...
0
votes
2answers
10k views

How to forward port on a dedicated windows server 2008?

In MSDN to make SQL Server accessible from Internet http://msdn.microsoft.com/en-us/library/ms175483.aspx They say to forward port from sql server remote port to usual sql server port 1443. I have ...
1
vote
1answer
3k views

install SQL Profiler for SQL Server Express

I am not sure what I did while installing SQL server express 2008 but sql profiler is not on my machine. is there a way to get that separately? my machine is not running on a server OS.
2
votes
1answer
247 views

NetWork Intrusion Attack: MSSQL.worm.helkern attempting to attack local port 1434 from IP address 94.188.21.147?

I was on the internet the other just finishing up a project for work and I saw my internet security saying network attack intrusion and I read about some of it but I can't fully understand the full ...
0
votes
1answer
2k views

SQL Server Management Studio: network-related or instance-specific error while establishing a connection to SQL server

SQL Server Management Studio: network-related or instance-specific error while establishing a connection to SQL server. Here's a screenshot of the error:
0
votes
1answer
249 views

How to determine sql server name

I'm trying to install sap business one on my computer. But I can't seem to connect to the database server which is ms sql. ![enter image description here][1] I get the notice: unable to connect to ...
0
votes
1answer
675 views

Database to a Network drive

What would be the syntax to backup MS SQL Database 2005 to a network drive?
0
votes
1answer
702 views

Why can't my bulk loadable CSV file be opened?

This is my error: Cannot bulk load because the file could not be opened. Operating system error code 5 (Access is denied.) I've checked permissions and everything seems fine. The auto bulk ...
1
vote
3answers
3k views

Windows Update KB2463332 Installs, But Still Available to Update?

I am running Windows 7 Home Premium on 64-bit architecture. Windows Update lists one "Important" update even though I've installed it. It is: KB2463332. There is no error when I install the ...
-1
votes
1answer
208 views

Enterprise Manager clone for SQL Server 2005 or later

Is there any project attempting to reproduce the functionality of Enterprise Manager for SQL Server 2005 and newer? I know Aqua Data Studio is sort-of-close. Are there any projects that understand ...
0
votes
2answers
617 views

Best SQL Server Configuration with this hardware

I just received my new SQL Server from Dell. The server will be serve approximately 15 OLTP databases which average 10GB in size. Here are the basic specs: Dell PowerEdge R510 with up to 12 Hot ...
1
vote
1answer
681 views

Timeouts when connecting to SQL Server since installing SP1 for Windows 7

I just installed SP1 for windows 7 and I have severe performance degradation when connecting to SQL Server 2005 since then. Establishing connection takes more than 30 seconds while it's instantaneous ...
0
votes
2answers
2k views

How to turn off IIS forever?

I have just installed Sql Server and it needed IIS. Now when I go to http://localhost/ I get -2147467259 (0x80004005) I bet its IIS. How to turn it off and remove it from autostart?
0
votes
2answers
1k views

Having problems with connecting to/seeing the local SQL server with Microsoft SQL Server Management Studio

I'm having some difficulties when I'm trying to connect to my local SQL Server. I'm pretty sure the server is running (many of the other topics on this subject suggests that the services might not be ...
0
votes
1answer
3k views

Accessing SQL Server in Windows XP Mode Virtual Pc

I have a laptop running 64bit Windows 7 Ultimate. I created a Virtual PC using Microsoft XP Mode. I've installed SQL Server 2000 on the Virtual Machine. I have SQL Server 2008 R2 installed on the ...
1
vote
1answer
371 views

Display corrupted with repeated scrollbar in SSMS Microsoft SQL Server Management Studio

Microsoft SQL Server Management Studio (SSMS) corrupts the display results and query window in both versions 2005 and 2008 as shown in the screenshot. It seems like the window drawing / re-drawing ...
1
vote
3answers
250 views

Could not find file 'SqlAccess.dll'

When running CREATE ASSEMBLY MyAssembly FROM 'S:\SourceCode\TryUDF\bin\Debug\TryUDF.dll' an error is returned: Could not find file 'SqlAccess.dll' in directory 'C:\Program Files\Microsoft SQL ...
0
votes
3answers
4k views

Recommended utility to import .csv files into Microsoft SQL Server 2008 R2?

I'd like a better method to import .csv files into Microsoft SQL Server 2008 R2. The default import wizard maps everything, by default, to a varchar(50), even when its quite obvious that its a columm ...
0
votes
3answers
711 views

Drupal 7 on Windows - File Module Problems

Installed Drupal 7 using the Web Platform installer on Windows 2008 For some reason, the file module, when you upload a file, uses the first few letters of the filename as the unique key to store in ...
0
votes
3answers
4k views

Dates not recognized as dates in pivot table pulling directly from SQL Server

My pivot pulls from an external data source with a date column. Excel doesn't see this column as a date and the 'Format Cells' option panel doesn't change how the dates are displayed. The cell data is ...
1
vote
2answers
2k views

MSDTC on server x is unavailable

I have Windows Server 2003 running in a virtual machine, running some software that is trying to update a database within transactions on my Windows 7 machine (the host for the VM). On my host I have ...
0
votes
1answer
3k views

Downloading MS SQL Server 2008 Standard edition

I want to download MS SQL Server 2008 with business intellegence standard edition. But I don't know how to download it, because the one I got was EXPRESS edition and everytime I run the x86 FULL 2008 ...
0
votes
1answer
82 views

Downloading MS SQL Server 2008 Standars

I want to download MS SQL Server 2008 with business intellegence standard edition. But I don't know how to download it, because the on I got became EXPRESS edition and everytime I run the x86 FULL ...
1
vote
4answers
10k views

SQL Server Management Studio - First Time Setup

I'm on Windows 7 and using free version of SQL Server Management Studio. I try connecting to DB server for the first time. I run the program as administrator. I go to Connect > Database Engine and ...
3
votes
1answer
4k views

How can I get sql server profiler installed

I have Sql Server 2008 R2 installed. But in Management Studio, under Tools menu, I don't see Profiler. What feature do I need to install in order to get profiler?
0
votes
1answer
2k views

Starting a SQL server on fedora

I am a total databases noob, hence please be gentle. I am looking for tutorials how to create a SQL table, how to start a SQL server, and what software to use on fedora. Would anyone share links to ...
0
votes
2answers
726 views

MSSQL Server Management Studio Express 2005 license limit error should not be displayed

I just tried restoring a 250MB database from a backup on my local machine, and got the following message: TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Restore ...
0
votes
2answers
2k views

Error code 0x80070001 on Windows Server 2008

I've been struggling to get Windows Server 2008 running on a virtual machine. I use VMplayer and want to install Windows Server 2008 Database and Enterprise from MSDN AA. The server is running now but ...
1
vote
3answers
1k views

Commas in Comma Delimited Files

I have a SQL export that is comma delimited, but some of the data has commas in it. Is there any way to fix this? I'm guessing I am going to have to re-export the data with a different delimiter.
1
vote
2answers
3k views

Convert MySQL backup (dump script) to MS SQL?

I have a mysqldump output of a fairly large (by measure of doing things manually) database saved in a text file. Does anybody know of a (free) way to use this to build a database in MS SQL? I'm ...
3
votes
1answer
5k views

Network Service Account password

In order to debug a SQL Server 2008 stored procedure, I would like to change the account that the SQL Server (MSSQLSrver) service is running under, namely, changing the account from "Network Service" ...
0
votes
0answers
689 views

SQL Server 2008 forgets my login and password

For some reason SQL Server 2008 (Management Studio) refuses to remember my username and password for a specific server instance even though I've checked "remember password" probably hundreds of times ...
1
vote
0answers
155 views

Errors while installing SQL Server SSIS 2005

I was trying to use SQL Server SSIS 2005 for the first time and mysteriously all the SQL SSIS menu items were missing from my start menu and then from the BIDS project choices even though I did a full ...
0
votes
1answer
229 views

Recover database (SQL Server) from Windows.old folder

I have just installed Windows 7 on a machine which previously ran Windows XP. The old installation had a database which I need a copy of, but of course I did not think far enough ahead to do a backup ...
1
vote
2answers
553 views

Database is full; what should be the strategy?

What if my database is full and I don't have any spare hard disk or memory space. What should my strategy to free up the space?
0
votes
2answers
535 views

Sql server - cant login to Sql Management Studio, username and pwd is correct

After a restart of the DB server last night, I cant seem to log in to SQL Management Studio - but I know that I have the right server name, user name and password. And I know the login details ...
5
votes
6answers
5k views

Why am I not able to create a backup plan for TFS?

I am trying to create a backup plan using the TFS Power Tools but I keep running into this error message: I have checked that the account has Full Control on the share, I can edit, create and delete ...
0
votes
1answer
120 views

How may I use other server features on Windows Home Server without breaking it?

I am hoping to run some virtual machines, IIS, SQL Server, MOSS, and Team Foundation Server on my HP MediaSmart Server 495, probably not all at the same time. There is a frightening warning message ...