Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2005]

Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This tag is for questions on the 2005 version

1072 questions
0
votes
1 answer

Can I replicated 2 SQL Server database with foreign key in some tables?

Assume I've 15 databases, 1 is main database and another is database located at various site. I need to create replication between main database and another. My fellows have tested replication and they conclude that replication can't working…
Ekkapop
  • 113
  • 1
  • 4
0
votes
1 answer

How to allow AppPoolService access to your SQL Server & database?

I have an IIS 7 server(2008 ) and ms sql server 2005 on the same machine. I want my application pool that was created to be able to access ms sql server 2005. How can I do this Set your app pool to a account (I think it is done - in the application…
chobo2
  • 461
  • 1
  • 10
  • 18
0
votes
1 answer

Unable to start MOSS 2007 services on Virtual machine (Virtual PC)

I am unable to start the MOSS 2007 services after everything has been installed perfectly. Any idea of what is going wrong? I have also installed SQL Server 2005 (Dev edition).
Falak Mahmood
  • 101
  • 2
0
votes
1 answer

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 corporate domain using VPN, still I'm not able to…
IsmailS
  • 101
  • 3
0
votes
1 answer

Automatic log truncation when scripting from SQL 2008 to 2005

I have to convert a sql server 2008 database to a sql server 2005 database. As far as I understand it, the only reliable way to do this is by scripting the database to an earlier server version. Now, my client has requested to 'get the database in…
HamiltonR
0
votes
1 answer

SQL 2005 Replication Error - Upgraded SP3

I recently upgraded my SQL 2005 server to SQL 2005 SP3. I have replication from SQL 2005 to SQL 2005 both are standard edition. During the upgrade I experienced no issues and the replication that was already setup continue to work great. I recently,…
Brennan Mann
  • 133
  • 1
  • 3
0
votes
2 answers

Options to handle corrupt msdb ldf file

Specs: We're using SQL Server 2005 with transactional replication. Our MSDB .LDF file has recently become corrupted, causing the MSDB db to be marked as 'suspect'. We read a bunch of stuff online and learned that to fix this you either have to…
user48662
0
votes
3 answers

Error in connecting SQL Server

I have a LAN network consisting of 2 laptops where my friend's laptop is acting as a server and my laptop is acting as a client...I could detect my friend's instance i.e PC/SQLEXPRESS an d so can he.... I have created a login name and password in…
sujitanand
0
votes
2 answers

SQL Browser Service vs. static port number: should I prefer one over the other?

Given that I have the choice, is there a reason to prefer enabling the SQL Browser Service over using the default static port, or vice versa? Here's the specific context: We have little third-party app with a few clients that connect to a 2005…
Matt
  • 218
  • 2
  • 5
0
votes
2 answers

Restoring Database on SQL Server 2005 Issues

I have created a backup of my production database and whenever I try to restore it on my local machine I get the following error: The media family on device C:\projects.......name_of_the_database_.bak is incorrectly formed. SQL SERVER …
user21004
  • 153
  • 1
  • 7
0
votes
3 answers

Auto-ban IP from connecting to SQL Server 2005 after n failed logons?

I'm helping a customer with an exposed SQL Server 2005. They will not budge on a firewall or VPN solution, and their logs are full of signs of a brute force attack. Is there way to auto-ban an IP address after X failed logons to SQL Server 2005?
NitroxDM
  • 635
  • 1
  • 15
  • 29
0
votes
2 answers

What really is DAC - Dedicated Administrator Connection in SqlServer 2005

What really is DAC? When is DAC to be used?
Julius A
  • 215
  • 3
  • 12
0
votes
1 answer

SQL ERROR: Verify that the instance name is correct and that SQL Server is configured to allow remote connections?

I am getting following error while connecting to my local Sql Express. An error has occurred. Details of the exception: A network-related or instance-specific error occurred while establishing a conne ction to SQL Server. The server was not found or…
user47094
0
votes
3 answers

BIDS and SSIS projects on SQL Server 2005

I have trouble just getting started with BIDS, the development environment for creating SSIS packages in SQL Server 2005. I don't know if it is just a license / version issue or if i am missing some components. If i install SQL Server Express 2005,…
Francesco Abeni
  • 575
  • 1
  • 4
  • 14
0
votes
3 answers

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 data. I think I read somewhere that I need to…
kylex
  • 1,421
  • 5
  • 14
  • 18
1 2 3
…
71 72