The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
27 views

Can't connect our ERP Database to MSSQL Server 2005

We have a Windows Server 2003 R2 using SQL Server 2005 Within the server are Two Lan Workgroup (IP Add 192.168.1.33 and 192.168.2.33) Neither IP has a problem connecting to the Server, their ping is ...
2
votes
0answers
112 views

Can't link Deltek Advantage 8.0 (Access 95 bookkeeping GUI) to SQL Server 2005

I have a client with an old 2003 server that bit the dust - I was able to recover the mdf/ldf of their project tracking database and am in the process of building a virtual machine to run it along ...
-4
votes
1answer
7k views

Installing SQL Server 2005 Express on Windows 8 [closed]

We have an application that installs a custom instance of Microsoft SQL Server 2005 Express as part if the whole installation process. Microsoft states that SQL Server 2005 Express is not compatible ...
0
votes
1answer
129 views

Automate install of SQL Server 2005 Express Service Packs

Is it possible to perform an unnattended install of service packs (SP4 is the latest) on SQL Server 2005 Express? The only way I have found is to download the SQLEXPR32.EXE containing SP4 and run it ...
0
votes
1answer
102 views

Space availability issue

I am using SQlserver2005. My database are becomeing very large and space is becoming very sparse. Please suggest what to do? (apart from buying space)
0
votes
1answer
91 views

Error Connecting to server with SQL Server Management Studio Express 2005

Problem logging in with SQL Server Management Studio Express 2005? When I try connecting to a server in SQL Server Management Studio Express 2005 with Server Name as PC-Name\MSSMLBIZ\SQLEXPRESS or ...
0
votes
2answers
2k views

SQL Server 2005 Express on Windows 7: Service does not start during installation [closed]

During SQL Server 2005 Express installation on a computer with Windows 7 Home Premium x64, the installation failed upon trying to start the instance service. No log file was created in the instance ...
1
vote
0answers
157 views

SQL server periodically gets disconnected

Our environment is: Windows Server 2003, Service Pack 2 SQL Server Express 2005 SQLServer JDBC driver 1.2 (also tried Jtds) Sun JDK 1.6 (we tried this on JDK 1.5 as well) There is no virus protection ...
0
votes
1answer
507 views

SQL Server Express 2005 SP4 Issues

After applying sp4 to sql server express 2005 and subsequent reboot, the service pack still appears as a needed update in Microsoft Updater.
1
vote
2answers
3k views

SQLExpress service unable to start Error code 17053

A user was instructed by their software support to upgrade a program and install SQLExpress as part of the installation process. Since that time, the service has been able to start, citing error ...
3
votes
2answers
615 views

How do I recover a dropped table from SQL Server Express 2005?

Something disastrous happened to me. I accidentally dropped my important table from SQL Server 2005 Express DB. Is there any way to recover that table with all records? Can DB Log file help? I have a ...
0
votes
1answer
556 views

Change the logical name of sql server express 2005 database file?

In Microsoft SQL Server Management Studio Express for Sql Server Express 2005, I needed to copy a database for testing and keep it on the same server as the old database. I did the following: Right ...
1
vote
1answer
760 views

Is there a maximum number of schemas allowed in SQL Server 2005?

What is the maximum number of user schemas one can create in a single SQL Server 2005 database? Is this figure different on SQL Server Express vs SQL Server Standard? I've searched the MSDN ...
1
vote
1answer
68 views

Avoiding SQL Server 2005 tables with same names, but with different owners

What is the most likely cause of this behavor with SQL Server 2005? TEST #1: I run Management Studio Express, connect to my local database with "windows authentication" and see that I have 1 ...
0
votes
1answer
280 views

Flush MSSQL Express in Memory Data to Disk Without Service Shutdown

I am attempting to configure a MSSQL 2005 Express db to flush its in memory data to disk so that the data can be captured by using disk snapshot software. I have been unable to find any particular way ...
1
vote
3answers
4k views

SQL Server access is slow on client machines

I was out on a clients site today and installed some custom software that accesses a SQL server 2005 database that resides on a server on the clients site. The software runs fine when ran directly ...
0
votes
1answer
188 views

SQL Server 2005 Express: Cannot install database diagram support objects

I'm refering to this question where the final solution was When I finally realized this, and connected via VPN to the corporate network, everything worked like a charm. Now in same situation I'm in ...
1
vote
3answers
1k views

SQL Server 2005 Express: Where is the Profiler?

i'm reading on Microsoft's site that SQL Server 2005 Express Edition has Profiler: Profiler Express Local and Relational Servers only. (i'm not sure what a non-relational SQL Server is, ...
1
vote
1answer
266 views

SQL 2005 Express: How to get those performance reports?

How do get go about being able to view those performance reports on SQL Server 2005 Express Edition; you know, these things (with the charts and bar graphs): What are they called What do i have to ...
0
votes
3answers
333 views

Exporting a MS SQL express database

I'm attempting to take a current website that uses MS SQL Express 2005 and create a redundant site on another domain. I've only ever worked with MySQL, and can't seem to find a way to export this ...
2
votes
4answers
787 views

Tune SQL Server Express using Profiler?

I have a SQL Server 2005 database... a copy of it is running in development on a full version of SQL server. Another copy is running in SQL Server 2005 Express on a web server. I've used SQL Profiler ...
0
votes
1answer
1k views

MS SQL Server 2005 Express rebuild master DB problem

There has been a power loss on our server and i cannot start the SQL service because the master DB is corrupted (as the log states). I found many articles recommending running the setup.exe with ...
1
vote
2answers
403 views

Tools for analyzing performance of SQL Server/Express?

The application that I have customized and continue to support for my client is seeing dramatic performance problems in the field. Simple queries on rather small datasets take over a minute when I ...
1
vote
2answers
1k views

Can't create add a SQL Server user: The login already has an account under a different user name

Environment: SQL Server 2005 Express Windows 7 When I installed SQL Server, I followed the instructions at http://msdn.microsoft.com/en-us/library/aa905868.aspx to set my computer's admin account ...
0
votes
2answers
144 views

SQL Server 2005 and SQL Server Express on the same machine?

Can we have both version installed on the same computer?
1
vote
2answers
221 views

SQL Server Express 2005 cannot connect

I have a SQL Server Express 2005 install on a godaddy virtual terminal which currently is only connected to(locally with mgt studio) every few days or so. Every time i try to connect I get a cannot ...
2
votes
2answers
471 views

SharePoint with SQL Server Express 2005

I am working on a development server with a bare-bones installation of SharePoint 12.0.0.4518 (WSS 3.0 RTM). Knowing very little about SharePoint development, we installed the environment atop a SQL ...
0
votes
1answer
1k views

How to DENY access for a particular database for login “sa” and grant access for another login? (SQL Server 2005 Express)

I have the SQL Server 2005 Express edition with "Mixed Mode authentication". So I want to create a database called "ActivityLogs" where I want to DENY access for the "sa" login. I want to create ...
2
votes
2answers
148 views

Can I install MS SQL Server Express 2008 on the same box as MS SQL Server 2008?

I am a developer and I wanted to ensure that I have a full MS SQL Server at my disposal if need be. Can I also install MS SQL Express 2008 on the same box, so I can do small dev projects using ...
2
votes
1answer
2k views

Keeping SQL Express below 4gb?

What would the recommended best practices to keep a SQL Express 2005 database below the 4gb limit? I am willing to export and archive content out of the data tables, but am not sure this will help ...
2
votes
1answer
1k views

windows 03 server has sqlexpress, but doing a netstat shows port 1433 is not listening

I did netstat -an | find /i "listening" I get ports: 80, 135, 445, 1025, 1026, 1056, 3389 but no 1433? I followed all the steps of allowing for remote connections that I could find, what could ...
0
votes
3answers
3k views

Does SQL Server 2005 Express default to TCP port 1433?

I am looking in SQL Server Configuration Manager, 'Protocols for SQLEXPRESS' And IP1, IP2, IP3, IP4, and IPALL have the TCP Port blank. Should that be 1433 or it will default to that?
0
votes
1answer
645 views

How do I enable SSL on SQL server express?

that is possible?, and then how?
2
votes
2answers
1k views

Replication with SQL Server 2005 Express Edition and SQL Compact Edition 3.5

I need some information on SQL Server 2005 Express edition. What I want to do is have my central database servin local machine databases IE back office Cental database ...
0
votes
2answers
401 views

User is not associated with trusted connection

I have a installed 2005 sqlexpress as well as express manager studio. I added a login under Logins, associated user with my database and gave it db_owner role under User mapping. Now I right click on ...
1
vote
1answer
1k views

Cannot stop SQL Server recovering database

I wanted to physically move the files associated with a database in SQLServer 2005 Express. I backed up the database, detached the database, copied the files to a different drive, and then reattached. ...
1
vote
3answers
965 views

Can't Upgrade an MDF from SQL 2005 - 2008

I'm trying to deploy an MDF file to my live server, but this also means going from SQL Express 2005 to 2008. I'm getting the following error in my web page. Database 'xxx.MDF' cannot be upgraded ...
0
votes
1answer
104 views

SQL Server queries take forever to enumerate the dataset?

I've got an interesting sounding problem with SQL queries run from a particular machine. This machine is a VM running Windows Server 2003, and it has SQL Server Express 2005 on it. The VM was ...
1
vote
2answers
443 views

Which Performance Counters to use for SQL Server 2005 Express

Usage Scenario I have a SQL 2005 database running in an instance of SQL Server 2005 Express Edition. There are two different .Net applications running that constantly connect to this database and ...
0
votes
4answers
757 views

Can I install SQL Server 2005 Express on a Windows Sharepoint Services 3 webserver?

I have a Windows Server 2003 machine that is dedicated to running Sharepoint Services 3. I need to host a new internal web application on this machine which requires SQL Server. I have already ...