SQL Server 2008R2 is Microsoft's latest public version of SQL Server, released April 2010.

learn more… | top users | synonyms

0
votes
1answer
403 views

Can't reset sa password

I am trying to drop and recreate sa account to reset the password. IF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'sa') DROP LOGIN [sa] GO I am getting an error Cannot use the ...
2
votes
3answers
317 views

Scaling Out SQL Server 2008 R2

I am looking into the possibilities of how to scale out the sql server 2008R2. simply scaling up wont be enough. "p2p replication" and "distributed partitioned views" look interesting, but both ...
-1
votes
1answer
217 views

Fresh install of SQLSERVER 2008 r2 Express, what's my server name? [closed]

See this image: http://imgur.com/WxAQc It's a fresh Win7 install, fresh 2008 r2 install. For the life of me I can't work out what to enter as server name, I've tried: TOM Localhost SQLEXPRESS ...
3
votes
2answers
6k views

How to update a CLR Assembly without dropping assembly from SQL Server

How can i update a CLR function (or procedure) assembly dll without having to drop and re-create the assembly in SQL Server (2008 R2)? As it stands now if i update an assembly (e.g. to add a new ...
0
votes
1answer
579 views

Password mismatch while logging to sql server

Alright, I have a classic asp application and I have a connection string to try to connect to db. MY connection string looks as follows: Provider=SQLOLEDB;Data Source=MYPC\MSSQLSERVER;Initial ...
1
vote
1answer
180 views

SQL Server 2008 R2 Backup

I see this error message in log BACKUP failed to complete the command BACKUP DATABASE model. Check the backup application log for detailed messages. SQL Agent is disabled. I never issued backup ...
1
vote
2answers
111 views

using win7 pc instead of windows 2003 server

Simple question, in terms of hosting an Asp.net-mvc/SQL Server 2008 R2 Express based app, will a powerful Windows 7 PC do? I just wonder if there is anything I'm missing here, being an App Dev and not ...
3
votes
4answers
388 views

Implications of having IIS on SQL Server 2008 R2 machine

an application needs to have IIS on the same box of Reporting Services. Today SSRS and SQL stay on the same clustered box. I need to evaluate the options which for me are: Installing IIS on both ...
2
votes
1answer
2k views

SQL Server 2008 R2 - RAM = 128GB, PageFile = 192GB?

Is there a definitive guide for PageFile size on the latest 64-bit servers with large amounts of RAM? I've seen conflicting recommendations, and am wondering if the latest releases have changed the ...
3
votes
4answers
1k views

Is there a performance advantage to isolating database logs and data on different volumes (same RAID array) across a SAN?

On my old server, I separated them on to different RAID arrays to improve performance. Using a SAN is new to me, so I'm not sure of the optimal configuration. SAN: 48 drives. 10K 600GB SAS. RAID 50. ...
0
votes
1answer
3k views

how remotely connect to sql server 2008-r2 installed on vps(virtual private network)? (firewall and sql server 2008 configs)

i have sql server 2008 r2 installed on a virtual private network (vps) with one ip valid ... my sql server instance info for connect on server(vps) is like below : server type: database engine server ...
0
votes
4answers
6k views

How to configure MS SQL Server 2008 R2 (login failed for user)?

I want to connect to database with such connection string: connectionString="Data Source=111.111.111.111;Initial Catalog=test;User ID=user;Password=password" So, I have default SQL Server ...
-1
votes
2answers
2k views

SQL Server: How to edit a view without scripting it?

How can i edit the definition of a view without having to "script" it in SSMS? The previous easy-to-use tools from Microsoft let me: Enter wait a moment Make change Carefully move mouse to large OK ...
0
votes
1answer
373 views

SQL 2008 R2 Active/Active/Passive Cluster Does Not Allow Linked Servers Both Ways

We are designing an active/active/passive failover cluster using SQL 2008 R2. We have two separate instances of SQL 2008: instance A is on node 1, and instance B is on node 2. Right now I'm trying ...
1
vote
2answers
754 views

Cannot resolve the collation conflict between “SQL_Latin1_General_CP437_CI_AI” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation

I'm trying to copy over a schema from one server to another, and I keep getting the following error and I have no clue where to start from to debug this issue... Error 2 SQL01268: .Net SqlClient ...
1
vote
2answers
676 views

Amazon EC2 MS SQL Instances

We have an Amazon EC2 box running the Windows Server 2008 with MS SQL Server 2008 R2. The default instance of the SQL server is running fine (the default MSSQLSERVER), we want to add a second one - ...
1
vote
2answers
383 views

How to migrate SQL 2005 to SQL 2008 R2 on new hardware with same server name

We have a need to migrate from existing hardware that is running SQL 2005 to new hardware running SQL 2008 R2. When all is said and done we want the same IP and hostname that was on the "old sql ...
0
votes
1answer
155 views

Audit Records queried from SQL Server 2008 (Database and Analysis Services)

I'm preparing a clinical data warehouse and I need to be able to audit the specific records that users query from either the relational database or the analysis services cubes. The key requirements ...
2
votes
1answer
303 views

Exceeding the DB size limit on SQL Server Express in READ_ONLY [duplicate]

Possible Duplicate: Can you help me with my software licensing question? If my database is larger than 10GB and I'm using it in READ_ONLY mode, will I be violating the licensing agreement ...
1
vote
1answer
2k views

sql server cluster - “the given network name is unusable” error in creation wizard

I'm trying to create a sql server 2008 R2 cluster. I've got two windows machines running server 2008 that are clustered and have all passed the validation tests etc. I'm now going through the ...
0
votes
1answer
103 views

Need help creating server out of Personal PC for small project

I have a Software engineering project in the near future in which a couple of students will be working on. I would like to host the database and maybe a source control server on my Local PC with hopes ...
0
votes
2answers
359 views

Is there any way to view history of time-zone settings in Windows Server 2008?

One of our servers has been set with an incorrect time zone for months and it has affected some of our data in SQL Server. Is there any way to see when time zone settings were made on the server?
4
votes
1answer
7k views

Difference between “SQL server 2008 standard” and “SQL server 2008 standard for small business”?

There seems to be a big difference in price for these licenses, but after a lot of googling I can't find any info on how the two compare. The blurb for the "small business" version is: "This edition ...
0
votes
3answers
3k views

How to get the most out of sharepoint 2010 with sql express database size limit?

We have had a consultant set up a sharepoint 2010 server for us to use for document management. I believe it is just on the basic (free) sharepoint that comes with windows server. From what I ...
0
votes
1answer
551 views

I can connect to a server via named pipes with sqlcmd but a vendor tool is getting Named Pipes Provider, error: 40

I have a windows service running on my workstation that is part of a vendor supplied tool that connects to a database. It will not startup the error I get 4 errors in the event log with the following ...
1
vote
0answers
39 views

Sql Server 2008 R2 Web Edition - an administrators guide?

I've been hunting around on Google and have so far failed to find a book or online guide for how to administer and lock down Sql Server 2008 Web edition. Specifically I've come from 10 years of MySQL ...
0
votes
1answer
125 views

SSRS Data Driven Subscription empty destination folder

I have a SSRS Data Driven Subscription, the reports are save to a folder, I use the Overwrite Write Mode, however there are old reports that aren't generated anymore that lingers on the folder, I ...
0
votes
1answer
78 views

Question on SQL Server 2008 R2 Web with 1 processor MOLP

My client are considering getting the above mentioned SQL server license but I have no idea of what MOLP is actually. Before I say "OK, go ahead" to them, I want to know something: Is the SQL ...
1
vote
1answer
871 views

Minimum SQL login permissions for an AD domain group

I've created a web application that uses a SQL Server 2008 R2 database in the background. Application uses integrated security SSPI connection to database so users need granted access to database ...
0
votes
1answer
159 views

Migrating databases from SQL 2000 to 2008 R2

Hands-ups, I have no idea what I'm doing! We have an old SQL 2000 Server with 2 databases. I have a new server running SQL Server 2008 R2. Can someone outline the basic steps of migrating the ...
1
vote
1answer
350 views

Can only debug once

I can only debug a query once, after that I get this error and have to restart Management Studio. Unable to start T-SQL Debugging. Could not connect to computer '(local)'. The requested name is ...
1
vote
2answers
128 views

SQL Server 2008 R2 installation/connection questions

I have a Windows Home Server connected to my home network on which I have just installed SQL Server 2008 R2, I am aiming to connect to the SQL Server installation from my laptop using SQL Management ...
0
votes
1answer
53 views

SQL Server 2008 R2 Transactions Files

Trying to restore a lost Server 2008 database. Had a backup from 2 weeks ago and were able to get the transaction log files. So I restored the DB in norecovery mode and started restoring the ...
0
votes
3answers
139 views

Does 250 MB SQL Server 2008 R2 space enough?

I'm about ordering a Starter Plan for my website hosting. my website is like a registration system for a small school, and it works only at the start of each term, so I'm wondering if 250 MB is ...
2
votes
1answer
424 views

Can I log ship from SQL Server 2008 R2 to Sql Server 2008 “R1”?

I have two sql server instances, on is SQL Server 2008 R2, one is the first release of SQL Server 2008 ("R1"), is it possible to log ship from the R2 machine to the R1 machine? If is not possible, is ...
3
votes
1answer
4k views

KB2494088 Always Fails : How to get it to install (or stop trying to)?

I have a problem where KB2494088 (a SQL Server 2008 R2 patch) continually fails to install when I reboot my system. Downloading the manual patch and trying to apply it says: The SQL Server patch ...
0
votes
2answers
161 views

Can connect to SQL Server remotely by port number but not by instance name

I have SQL Server 2008 R2 Datacenter running on Windows Server 2008. I am unable to connect to a named instance \SQL2008R2 using its instace name over the internet from my development machine (e.g. ...
1
vote
2answers
86 views

Is there a performance hit when using an external URL rather than an internal IP to address a server in SSIS?

I'm running SQL Server Integration Services (SSIS) packages in SQL Server agent every day. I've been monitoring the performance of the packages and see a lot of network activity in Resource Monitor. ...
0
votes
1answer
274 views

SQL 2008 R2 Bi directional replication

I'm looking for the right replication for my case: I can't use P2P replication because one of my SQL's is Standard. I have 2 SQL 2008 R2 and want to create a bi-directional replication. What are my ...
1
vote
1answer
508 views

Report Server w/ SQL 2008 R2 Express - Can't login to Manager URL

I just installed Report Servicing addon (Advanced Services) to a local SQL Express 2008 R2 server. I have the configuration tool and setup the proper URLs but when I connect to them I get permissions ...
0
votes
1answer
170 views

MS-SQL Server 2008 size limitation on data

I recently discovered that MS-SQL Server 2008 imposes an upper limit of 8000 bytes for a column (for character data). I need to store data that occusionally could surpass this limit. Is there a way to ...
0
votes
1answer
148 views

SQL Transaction Replication prevents procedure with distinct on varchar(max)

When I'm adding one procedure article to the Publication the I get this error: The text data type cannot be selected as DISTINCT because it is not comparable the proc is a simple select distinct ...
2
votes
1answer
205 views

SSIS 2008 R2 performance and Windows 2008 R2 clustering question

I am testing different configurations for loading data from a remote SQL server using SSIS. In a clustered situation SSIS seems slower to speak to the local clustered SQL instance when compared to a ...
-1
votes
2answers
3k views

SQL Server 2008 update License

How can I change my SQL Server 2008 license? I have the Enterprise Edition installed with a 90-day key and it will expire on 7 days. Two months ago, I purchased the final one but I don't know how to ...
0
votes
2answers
246 views

SQL Server 2008 login failed

I have a virtual machine (vmware) with Windows Server 2008 R2 x64 and SQL Server 2008 R2 installed. I see 2 SQL Server services on this vm : sqlexpress, mssqlserver. Both of them are use the default ...
3
votes
2answers
8k views

How to shrink 40GB LOG file

I have a problem that is my log file in SQL Server 2008 is grown to 40Gb and I wanted to shrink it. The query I am using is ALTER DATABASE DatabaseName SET RECOVERY SIMPLE use DatabaseName GO ...
2
votes
2answers
2k views

What is maximum memory supported for Microsoft SQL Server Standard Edition (64-bit)

I have Microsoft SQL Server Standard Edition (64-bit) running on Windows Server 2008 R2 Standard (64-bit) with 32GB RAM. It's only database server that runs on this machine. Generally it works fine ...
0
votes
1answer
602 views

Performance implications of running SQL Server 2008 in a virtual machine

I have a bare-bones Windows 2008 R2 Enterprise production server running SQL Server 2008 R2 Enterprise. We have a faster server that isn't being utilized and I'd like to move the production database ...
2
votes
1answer
207 views

Creating a small .bak file without indexes or excessive log

I recently was asked to ship a .bak file of our database to a client, and through reindexing all tables with a 100% fill factor (to make sure there were no empty slots), and resizing the transaction ...
1
vote
2answers
232 views

SQL2008R2 Server access to XML templates in IIS7

I'm in a jam. working on a migration project from SQL 2000 to SQL2008 R2 on a windows 2008 R2 box with IIS7 now installed. The old server had 3 simple virtual directories with XML templates installed ...