tblMashedUp

SQL Posts

Clustering

SQL Server and SQL Server Agent service cannot start on third serv

We have 2- node Windows Enterprise 2003 x64 servers clustered in
active/active configuration with SQL 2005 x64 installed on it. Both servers
are domain controllers.
Now we try to add another node to the cluster. This third server is not
domain controller. We added new node to cluster and this work fine. Cluster

12/3/2009 2:40:01 PM

NNTP Clustering

SQL Server and SQL Server Agent service cannot start on third serv

We have 2- node Windows Enterprise 2003 x64 servers clustered in
active/active configuration with SQL 2005 x64 installed on it. Both servers
are domain controllers.
Now we try to add another node to the cluster. This third server is not
domain controller. We added new node to cluster and this work fine. Cluster

12/3/2009 2:40:01 PM

NNTP Clients

Concurrenct problem

Hi All,
On my web application(C#) we have a transaction and within the transaction we are calling a store procedure. And after the execution of store procedure we are committing the transaction.
Inside the store procedure we are fetching a value (an integer) from a column(table) and using the same value incremented by 1 we are updating the same column for the next record. THis works fine when users are hitting the SP at different times.

12/3/2009 2:13:34 PM

NNTP Clients

Native client compatibility

I have questions regarding SQL Server Native Client.
Can I connect to SQL 2008 with SQL 2005 Native Client and if so are there
any limitations?
Can I connect to a SQL 2005 Server with a SQL 2008 Native client and if so
are there any limitations?
Thanks
Frede

12/3/2009 10:45:01 AM

NNTP Connect

2147467259 intermittent mid day errors

We are running 3 clients against 1 Sql Server and at some point (usually in the afternoon) 1 of the clients(MTS server) is unable to initialize a connection with 2147467259 Data provider cannot be initialized.
The problem is intermittent. Each of the clients uses the same connection string to open an ADOConnection. Usage on each of the clients has been reported as relatively consistent; no huge peaks or memory issues. 2 clients may be totally unaffected at the time when one is unable to connect. Eventually the ability to connect may be restored. Any help is appreciated.

12/1/2009 9:54:35 AM

NNTP Clients

Access 2007 adp & SQL Server 2008-issues with subforms

Hi! We transfered our DB from SQL 2005 to SQL2008 by creating scripts in SQL
Studio2008. After that we can't update correctly records in subforms(if this
subform have two tables as datasource).
For example:
We have
A ([ID] [int] IDENTITY(1,1) NOT NULL,[LASTNAME] [nvarchar](56) NULL)
B ([ID] [int] IDENTITY(1,1) NOT NULL,[TITLE] [nvarchar](56) NULL)

11/30/2009 7:38:01 PM

NNTP Connect

Can't connect to SQL Server 2008

The SQL Server 2008 is, and has been, running on Windows 2008 Server. I had a
client development machine running Vista 32-bit/VS2008 which could access
this server.
I wiped that client machine and loaded Windows 7 64-bit and VS2008. Now my
VS solution cannot connect to the SQL Server. It times out.

11/30/2009 6:50:01 PM

NNTP Clients

Getting OLAP partitions to show in the correct order

I have just had a new PC and MS SQL Server 2005 client software was installed
on it. When I open our OLAP database right down to the partition level the
partitions show in the order they were created and not the order of their
name. The partitions have a common name followed by a week number. On my old

11/28/2009 10:43:01 AM

NNTP Connect

SQL Server 2005 Connect at Run Time

Hi.
I had created a DB on Sql server 2005 Instance
Db Named 'My_Db.mdf" with My_Db_Log.ldf file .
After that i had detached it.
I had copied on my USB Pen Driver. All works Fine.
Now the problem became HARDER (for me)
On my USB Pen Driver the Mdf and Ldb file must be named 'Demo_Db'
Demo_Db.Mdf and demo_Db_Log.Ldf

11/28/2009 8:40:01 AM

NNTP Clients

Configuration wizard for SQL 2008 Developers Training Kit stops

I installed and ran some of the demos of Microsoft SQL Server 2008 for
Developers Training Kit -- including creation of global alias and all common
databases.
Environment: Windows VISTA Business SP2 , MSSQL 2008 Express, MSSQL named
instance MyComputerName\SQLEXPRESS. No other instance is installed on my

11/24/2009 11:30:01 PM

NNTP Clustering

CLUSTER UPGRADE MESS

We had 2 Active/Passive cluster on Windows 2003 SP2 - SQL Server 2005 EE SP3,
Cumulative patch 1 -------> 32 bit SQL Server on 64 bit O/S.
We wanted to upgrade to SQL Server 2008. First of all, Installation CD
defaulted to X64 directory assuming that since the O/S is 64 bit, SQL Server
must also be 64 bit and that was not the case. We copied the contents of the

11/23/2009 8:56:01 PM

Clustering

CLUSTER UPGRADE MESS

We had 2 Active/Passive cluster on Windows 2003 SP2 - SQL Server 2005 EE SP3,
Cumulative patch 1 -------> 32 bit SQL Server on 64 bit O/S.
We wanted to upgrade to SQL Server 2008. First of all, Installation CD
defaulted to X64 directory assuming that since the O/S is 64 bit, SQL Server
must also be 64 bit and that was not the case. We copied the contents of the

11/23/2009 8:56:01 PM

Clustering

How many nodes can SQL Server Clustering 2008 support?

How many nodes can SQL Server Clustering 2008 support? and How many ACTIVE nodes can SQL Server Clustering 2008 support? Thanks.
EggHeadCafe - Software Developer Portal of Choice
Fiddler Tips & Tricks
[link]

11/23/2009 2:46:34 PM

NNTP Clustering

How many nodes can SQL Server Clustering 2008 support?

How many nodes can SQL Server Clustering 2008 support? and How many ACTIVE nodes can SQL Server Clustering 2008 support? Thanks.
EggHeadCafe - Software Developer Portal of Choice
Fiddler Tips & Tricks
[link]

11/23/2009 2:46:34 PM

Clustering

Installing Reporting services on a cluster

Hi,
We have an existing production clustered SQL server with a default instance
and a named instance. I need to configure Reporting services on the named
instance but am getting the error "Existing cluster or cluster prepared
instance failed".
Has anyone installed RS on a SQL cluster, can you please give me some steps?

11/21/2009 3:12:01 AM

1 2 3 4 5 6 7 8 9 10
11 12 13 14 15 16 17 18 19 20
21 22 23 24 25 26 27 28 29 30
31 32 33 34 35 36 37 38 39 40
41 42 43 44 45 46 47 48 49 50
51 52 53 54 55 56

pBlogCategories

sys.books