Questions tagged [sql-server-2008]
A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.
1,806
questions
0
votes
1
answer
184
views
Don't have permission to access SQL Server Express 2008? [duplicate]
Possible Duplicate:
Don’t have permission to access SQL Server Express 2008??
I have a remote PC with SQL Server 2008 setup and allowing remote connections.
I am an Admin user on the PC and have ...
1
vote
1
answer
3k
views
Why does Server 2008 running SQL 2008 produce a FlushFileBuffer exception?
I run 64bit SQL2k8 on 64bit WS2k8, and backup a database to a UNC file. The backup creates the file, copies the data, and when finishing, crashes.
Backup database Infovest to disk = '\riscsrv-dcm04\...
0
votes
2
answers
162
views
Pointers on managing database with 4000 tables?
I'm in the middle of designing a software system storing data in about 4000 tables in Microsoft SQL Server 2008. Does anyone have any pointers to ease management of such a large number of tables?
...
0
votes
1
answer
1k
views
SQL Server 2005 - My Linked Servers to it are broken now!
I'm a programmer working over a VPN.
I use local databases most of the time, but my local SQL Server 2005 has "Link Server" server object pointing at the production server.
This has been working ...
2
votes
1
answer
4k
views
how to see SQL Server cache hit rate?
I am using SQL Server 2008 Enterprise. I will issue a lot of query to SQL Server. And I think SQL Server itself will use some optimization internally, like pre-fetching data into SQL Server internal ...
0
votes
1
answer
2k
views
Where can I get Windows2003 SP2 FileStream HOTFIX?
When I was installing SqlFailover Cluster, at one stage before installing SQL Server it shows:
Windows2003 FileStream HOTFIX failed.
So I think this is not installed. Where can I get it?
1
vote
3
answers
790
views
Can you make MS Sql Server reject all queries matching a certain pattern?
I would like to know if you can make Sql Server look at incoming query strings and reject ones that match a certain pattern. In other words, for a certain class of queries (perhaps identified by a ...
1
vote
3
answers
2k
views
How to install sqlserver2008 failover cluster on windows2003 server?
Can any one give me the procedure to create a failover cluster on windows2003???
Any links would also be helpful.....
I got warning messages on MSDTC such that MSDTC is not running on local machine. ...
0
votes
2
answers
186
views
SQL Server Hosting
I am looking for a SQL Server Hosting Provider that meets the below requirements:
Using SQL Server 2008 Standard or Enterprise Edition (No EXPRESS)
Allows directly connecting from SQL Management ...
3
votes
3
answers
33k
views
Installing ONLY SSIS and not the whole SQL Server system?
I have a production SQL Server 2008 running on Windows Server and I do testing and development on my laptop. My laptop is running Win XP and SQL Server Express 2008.
In addition to having SQL Server ...
4
votes
4
answers
1k
views
Optimal SQL Server Reporting Services setup
I'd like to determine an optimal setup for SQL Server Reporting Services to use as the integrated reporting tool for SaaS web-based applications. All reports are pre-defined, so users pick a report ...
4
votes
1
answer
8k
views
Problems with SQL Server 2008 - "The client was unable to reuse a session with SPID 62, which had ..." [closed]
I'm having problems with my SQL Server 2008 installation (10.0.2531.0 - SP1 installed). It works as a database server for small hosting environment (about 500 sites).
I'm getting errors like this:
...
1
vote
3
answers
4k
views
SQL 2008 reporting services with SQL 2005 server
Is it a supported configuration to be run a SQL 2008 reporting services server with a SQL 2005 database server?
Either way, where can I find supporting documentation?
2
votes
3
answers
532
views
Performance of Locked Pages v Native memory on 64 bit SQL2005/2008
I understand that setting the lock pages in memory privilege to the service account housing SQL2005/2008 services on a 64 bit system uses the AWE API and effectively stops SQL's buffer pool from being ...
11
votes
6
answers
71k
views
cannot add a user to sysadmin role in SQL Server
I am using SQL Server 2008 Management Studio. The current logon account belongs to machine local administrator group. I am using Windows Integrated Security mode in SQL Server 2008.
My issue is, ...
3
votes
4
answers
8k
views
SQL Server 2008 remote logins fail, local succeeds, remote logins enabled?
I'm running SQL Server 2008, with remote connections enabled, and mixed Windows Authentication and SQL Server Authentication enabled. The logins I have setup (Windows and SA) work fine from the server....
0
votes
2
answers
1k
views
Sql Server 2005 Express & Sql Server 2008 side by side
I have a Win2003 system that serves CAD drawings thru an SQL SERVER 2005 Express.
I need another installation of SQL SERVER 2008 for an ERP on the same server.
There are any known problems or issues ...
1
vote
3
answers
126
views
SQL server 2008 Data Compression
On my OLTP database server main performance bottleneck is I/O.If i compress my database,as per my calculations i will have 60% compression.As pages in memory also have compressed data,lot more data ...
0
votes
3
answers
1k
views
Cannot start SQL Server PowerShell
Have you guys had this problem where, when you start PowerShell from SQL Server, it throws an exception like the following?
Cannot resolve alias 'cd' because it
refers to term
'Microsoft....
2
votes
2
answers
2k
views
SQL 2008 evaluation expired - how long will the DB continue to work?
We've got an instance of SQL Server 2008 running in production and I had no idea it was a trial version - until it expired! Now I can no longer run SQL Management Studio and SQL Reporting Services ...
0
votes
2
answers
5k
views
SQL Server 2008 Remote Access
I'm having problems connecting to my SQL Server 2008 database from my computer. I have enabled remote connections as described in this answer (How to enable remote connections for SQL Server 2008?). ...
0
votes
4
answers
6k
views
SQL 2008 Replication over Internet
We have decided to put our servers in data centers on east and west coast of US, to keep high level redundancy. After evaluating number of replication options, apart from VPN there is no other way to ...
11
votes
6
answers
20k
views
How can I have SQL Server Management Studio 2008 connect to my instances automatically?
I'm running a server with 3 database instances.
Right now, when I open Management Studio, it opens the "Connect" prompt that lets me choose which instance I want (or connect to anything else).
Would ...
3
votes
2
answers
2k
views
Unable to uninstall SQL Server express
When I try, I receive the following error message:
A computer restart is required. You
must restart this computer before
installing SQL Server.
Of course, I have restarted the computer :-) I'...
0
votes
1
answer
803
views
SQL 2008 Datawarehouse Collection Agent Fails with Mirrored Databases on instance
I have a data collection job that fails when a Database on the instance is in Recovery Mode. The database in recovery is the MIRROR partner in the database mirror.
The Job that fails is as follows.
...
0
votes
2
answers
172
views
Why do I only see the 'default' DB when linking an Oracle server in SQL Server 2008 Mgmt Studio?
When I add an Oracle server as a Linked Server in SQL Server 2008 Management Studio, I can only see a database named 'default', and none of the other DB's on the server. Using Microsoft OLD DB ...
0
votes
3
answers
4k
views
How do I resolve the error "The file exists" when restoring a cube backup?
I'm trying to restore a cube backup (a .abf file) using SQL Server Management Studio, but I'm getting the error message:
The following system error occurred: The file exists. . (Microsoft SQL ...
2
votes
3
answers
631
views
Move SQL Server 2008 Web Edition
Ok long story short, at work I've run into the nice situation of having to move our SQL Database from one server to another. We got in touch with our hosting provider and got set up a new server (we ...
2
votes
4
answers
628
views
What should I do to scale OUT a Sql2008 database?
I'm about to scale UP our sql2008 database. Simple. But I might need to scale OUT our sql databases.
For a simple scale out situation (ie distributing the processing load), are there some good ...
3
votes
3
answers
8k
views
Is there a 64 bit version of SSMS and BIDS with SQL Server 2008 64 bit?
Yesterday we had a very heated discussion at work regarding the availability of a 64 bit version of SSMS and BIDS with SQL Server 2008 64 bit.
While I know for sure that such a thing does not exist ...
3
votes
2
answers
355
views
Can I still use WMI to manage SQL Server 2005 and 2008?
I've seen some articles on how to use WMI to manage SQL2000 servers (after installing SQLWMI80.msi manually) but I've not seen anything about this for SQL2005 and SQL2008.
Has this been depreciated? ...
1
vote
1
answer
190
views
SQL 2008 SP1 on XP
Is SP1 for Microsoft SQL 2008 supported on Windows XP?
The list of supported OSes doesn't have XP. But SQL 2008 STD Edition is supported on XP SP3.
2
votes
3
answers
1k
views
How can I tell what user account is being used to perform an action (in context of SQL Server)?
For example, when installing SQL Server 2008, I had to pick an account for the database engine to run as.
When I went to attach a 2005 database file with SQL Server Management Studio, there was a ...
3
votes
2
answers
1k
views
Locked out of SQL Server 2008
I've got an SQL server 2008 server which appears to have had all it's windows users removed from the logins and is set to windows authentication only. I can't login with any of my AD/Doman accounts or ...
3
votes
2
answers
2k
views
Setting Up Login for ASP.NET Application on SQL Server 2008
I have 2 Windows 2008 Servers. One is a web server (IIS7). The other is a database server (SQL Server 2008). The instance of sql server 2008 is configured to use mixed mode authentication. Neither are ...
5
votes
2
answers
2k
views
SQL Server 2008 Trace Flag 4135
Does anyone have any idea what this flag does? There is no reference to it on MSDN. It is not a part of the article that lists available trace flags in 2008.
There is a KB article that recommends ...
0
votes
6
answers
9k
views
Connecting remotely to an SQL server inside a LAN
I am using SQL server 2008 inside my home lan. I've configured it to accept remote connections and I can now connect to the server from other pcs inside the lan.
The problems rises when I try ...
0
votes
1
answer
864
views
Connecting remotely to an Sql server inside a LAN
Hello everyone,
I am using sql server 2008 inside my home lan. I've configured it to accept remote connections and I can now connect to the server from other pcs inside the lan.
The problems rises ...
5
votes
5
answers
18k
views
Remote connection sql server not working but if firewall disabled it does?
I have setup sql server express 2008 on a windows 2008 server. And i have done all the standard stuff in sql to allow remote connections. The strange thing is if i disable the windows 2008 server ...
0
votes
5
answers
9k
views
Cannot backup databases from SQL Server 2008
I'm trying to back up the SQL Server 2008 database on Windows Server 2008, using instructions from:
http://msdn.microsoft.com/en-us/library/ms253070%28VS.80%29.aspx
Everything is pretty ...
3
votes
1
answer
5k
views
Sql server has detected a non canonical discretionary access control list
After installing SQL Server 2008 Enterprise I received three error messages like this: Setup has detected a non canonical discretionary access control list (DACL) on directory 'c:\Program Files\...
4
votes
5
answers
8k
views
Replaying SQL Server transaction logs on changed db schema
We have a big transaction log (1.3 GB) for a relatively simple SQL Server 2008 database (30 MB). It (log) contains all updates since first time when db was put into production and (now we see it) ...
3
votes
2
answers
371
views
Selecting a Disk Subsystem for SQL 2008 / Hyper-V
I currently have a medium-sized (4GB) SQL Server 2005 database running on a 3-year old Windows 2003 Server. [Xeon 2.8-2core, 2GB, 2x 73GB SCSI 10k - RAID 1]. This DB back ends an ASP.NET OLTP ...
4
votes
5
answers
8k
views
SQL Server 2008 Load-Balancing
The info I've found on the web so far indicate that SQL Server 2008 does not support true load-balancing.
Is this true? I'm not able to find decent documentation on MS' site, so any links would be ...
2
votes
3
answers
3k
views
Enabling filestream on SQL Server 2008
When trying to enable filestream to a SQL Server 2008 I've got this message:
There was an unknown error applying the FILESTREAM settings. Check the parameters are valid.
And now in the FILESTREAM ...
0
votes
1
answer
13k
views
How do I connect to NAMED INSTANCE of SqlServer 2008 running on custom port from another network?
I have a named instance of MS SQL Server 2008 running on port 1456. TCP/IP and NamedPipes are ENABLED for the server. No Aliases created.
local address: 192.168.1.123\RM - works from local computer ...
2
votes
2
answers
8k
views
Is it possible to track who is running SQL Server Profiler?
Is it possible to see who is running SQL Server Profiler against a certain database and possibly from what machine? Say through Profiler itself or by T-SQL statement.
I wonder if it is even possible ...
0
votes
4
answers
2k
views
Blackberry Enterprise Server 5.0 and SQL server 2008
About to install BES 5.0 and have a SQL 2008 install that I can point it to. It looks like RIM doesn't officially support SQL 2008, only 2005, so am wondering if any server fault peeps have it ...
7
votes
5
answers
3k
views
Why is CPU use so asymmetric on our 8-cpu SQL Server box?
I've noticed that the CPU usage on our 8-CPU database server, running SQL Server 2008, is not balanced at all.
Here are the 1 day averages for a random day a while back, which is typical and ...
2
votes
3
answers
2k
views
Limit on number of databases to mirror (MS SQL 2k8)?
I am implementing an SQL failover strategy for ms-sql 2k8, and am thinking of going with database mirroring. I've read that it's not intended for a large number of databases - however the article did ...