cluster white paper

Is there a reliable white paper for clustering sql2k on win2k3. Ive already
got the OS clustered.
SQL2K SP3
TIA, ChrisRChrisR wrote:
> Is there a reliable white paper for clustering sql2k on win2k3. Ive
> already got the OS clustered.
Some of these might help:
http://www.microsoft.com/resources/...r />
1261.mspx
http://support.microsoft.com/defaul...blurb101802.asp
http://msdn.microsoft.com/library/d...
ering_2icn.asp
David Gugick
Imceda Software
www.imceda.com|||This is great information. Does anyone have any updated information on
setting up SQL Server 2000 in a Windows 2003 environment?
Just wondering if 2003 brings anything more to the table over Windows Server
2000.
Thanks!
Tony
"David Gugick" wrote:

> ChrisR wrote:
> Some of these might help:
> http://www.microsoft.com/resources/.../>
/c1261.mspx
> http://support.microsoft.com/defaul...blurb101802.asp
> http://msdn.microsoft.com/library/d...tering_2icn.asp
> --
> David Gugick
> Imceda Software
> www.imceda.com
>

ClubSite template + sql server 2005 not cooperating...

I've managed to get the clubsite template from asp.net up and running, sorda (http://www.flysniper.com), I get a system error which I believe is related to the fact that my DB isn't working correctly.

I'm trying to configure it to work with ms sql server 2005 which is running on the same machine as the website.

I've followed the instructions of Scott Gu (http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx)

while trying to run aspnet_regsql.exe I get the following error

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql.exe -S XXXXXXXXXX
-U YYYYYYYY -P ZZZZZZZZZ -A all -d flysniper

Start adding the following features:
Membership
Profile
RoleManager
Personalization
SqlWebEventProvider

.................
An error has occurred. Details of the exception:
An error has occurred while establishing a connection to the server. When conne
cting to SQL Server 2005, this failure may be caused by the fact that under the
default settings SQL Server does not allow remote connections. (provider: Named
Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Unable to connect to SQL Server database.

I have tried several different things (shooting in the dark) to resolve this issue, including:

verifing that port 445 is avaliable on the firewall per these directions:http://support.microsoft.com/default.aspx?scid=kb;en-us;839269

configured SQL server 2005 to allow remote connections following these directions:http://support.microsoft.com/kb/914277

with no change in results.

Anything else I should look into?

Thanks in advance,

Mike

I get that message when I forget to start sql server before trying to connect to the website.

|||

LockH - thanks for your response, I have confirmed that the SQL Service is up and running.

UPDATE: I have managed to get the aspnet_regsql.exe to run and the tables are created.

I have tried to set the connection string up correctly: <addname="ClubSiteDB"connectionString="Data Source=StormTrooper\FlySniper;Initial Catalog=FlySniperDev;Persist Security Info=True;User ID=XXXXXXXXXXXXX;Password=YYYYYYYYYYYY;"providerName="System.Data.SqlClient"/>

I think its just a switch somewhere that I'm missing.

I have set up a developer website for testing purposes, please usehttp://dev.flysniper.com/flysniperClubSite to see the actual error.

TIA,

Mike

|||

Did you create the tables in the database on the server, or did you copy the database files from your dev machine?

If you copied the database files onto that machine, did you go into database admin and attach the database files to that server?

|||

The tables were created directly on the server. It's my personal machine so I have direct access to it.

Thanks for you time,

Mike

CLR Stored proc is timing out

At one seemingly inoccuous step in my CLR stored procedure, execution stops
and the query times-out.
I've tried debugging the stored proc by stepping into it from within VS.
When I do, I get to the code in question, but then simply get this message:
WARNING: Debugger was accessing T-SQL variables while managed code was not
suspended.
Waiting until the access is done to continue T-SQL execution.
Continueing T-SQL execution.
And these messages appear to repeat indefinitely. I'm running SQL Server
locally on my machine, but this also happens on out development SQL Server
server.
The place in the code it appears to happen is when returning back results
from a lower-level CLR stored proc called within the higher-level CLR stored
proc -- when piping the result set, I suppose.
I've set MAXDOP to 1. No help there.
Anyone know what's going on?
Hello Quimbly,

> The place in the code it appears to happen is when returning back
> results from a lower-level CLR stored proc called within the
> higher-level CLR stored proc -- when piping the result set, I
> suppose.
Can you be a bit more specific about what you're doing?
Is your CLR proc calling another CLR proc without in parameter passed as
ref out out? How are you executing the other stored procedure.
Note: a better newsgroup for this would be Micorosoft.Public.SqlServer.CLR,
I've copied this there.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
|||> Can you be a bit more specific about what you're doing?
The top-level CLR proc calls a regular static method in the SQL CLR project.
This static method makes a call to another SqlProcedure (static method
tagged with [Microsoft.SqlServer.Server.SqlProcedure] attribute).
The static method is calling the lower-level CLR proc as follows:
string sqlString = "LC_SP_ScheduleEvents_SelectForDate";
SqlCommand command = new SqlCommand(sqlString, connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@.P_LuminaireID", luminaireID);
command.Parameters.AddWithValue("@.P_TargetDate", usageDate);
command.Parameters.AddWithValue("@.P_TargetDateStar tInUTC", startTimeUTC);
command.Parameters.AddWithValue("@.P_TargetDateEndI nUTC", endTimeUTC);
SqlDataReader reader = command.ExecuteReader();
//...
Inside the LC_SP_ScheduleEvents_SelectForDate proc, it times out when it's
piping it's results back:
I.e.:
...
for (int i = 0; i < dr.Length; i++)
{
// send one event
eventRow = new SqlDataRecord(eventRowMetaData);
eventRow.SetSqlBoolean(0, bool.Parse(dr[i]["IsLampOn"].ToString()));
eventRow.SetSqlDateTime(1,
DateTime.Parse(dr[i]["ActualEventTime"].ToString()));
eventRow.SetInt32(2, int.Parse(dr[i]["DimmingLevel"].ToString()));
SqlContext.Pipe.SendResultsRow(eventRow);
}
}
SqlContext.Pipe.SendResultsEnd();
|||Hello Quimbly,
I know this seems lame, but I suspect you have a reference type issue here.
Try assigning IsLampOn, ActualEventTime and DimmingLevel to local value types,
then sets those into the DataRecord.
Its low hanging fruit to solve first.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/

CLR integration & clustering....question

If I've got a small CLR procedure that I'm now using thanks to 2005,
and I'm running on a failover cluster....do I need to have the DLL
available on both nodes of the cluster at the same path? So when I
fail over, the SQL Assembly knows where to go find it?
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1137791687.994902.215830@.f14g2000cwb.googlegr oups.com...
> If I've got a small CLR procedure that I'm now using thanks to 2005,
> and I'm running on a failover cluster....do I need to have the DLL
> available on both nodes of the cluster at the same path? So when I
> fail over, the SQL Assembly knows where to go find it?
>
CLR Assemblies are stored in the databse, not the filesystem.
So they are shared by both nodes.
David
|||I see - so once you load them using Create Assembly, their put in a
system table somewhere and loaded & accessed from there & not the
filesystem?
|||"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1137792522.275215.162630@.g14g2000cwa.googlegr oups.com...
>I see - so once you load them using Create Assembly, their put in a
> system table somewhere and loaded & accessed from there & not the
> filesystem?
>
Correct. Also this keeps assemblies in different databses from stepping on
each other.
David
|||You can see them in the sys.assemblies catalog view (and the actual content
in binary format in the content column of sys.assembly_files). For a list of
the functions/procedures etc they export you can have a look at
sys.assembly_modules
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1137792522.275215.162630@.g14g2000cwa.googlegr oups.com...
>I see - so once you load them using Create Assembly, their put in a
> system table somewhere and loaded & accessed from there & not the
> filesystem?
>
|||Thanks - this is great info...
Jasper Smith wrote:[vbcol=seagreen]
> You can see them in the sys.assemblies catalog view (and the actual content
> in binary format in the content column of sys.assembly_files). For a list of
> the functions/procedures etc they export you can have a look at
> sys.assembly_modules
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "Corey Bunch" <unc27932@.yahoo.com> wrote in message
> news:1137792522.275215.162630@.g14g2000cwa.googlegr oups.com...

Client-side xml updates and commits

Hi, I've been digging through online docs to see if SQLXML can do what I'm
hoping, and articles say it can, but not how...
My SQL database has regular relational tables, which I'd like to query
through xpath from a C# app, get the data returned to an XmlDocument (or
XPathDocument, but not a DataSet, which I found a sample for), use XPath to
make changes to the XmlDocument, and then commit the changes back to the SQL
tables.
The bottom of this page:
http://blogs.sqlxml.org/bryantlikes/...10/29/200.aspx regarding
Whidbey features, says "XmlAdapter - like SqlDataAdapter, fills an
XPathDocument from SQL Server, updates the changes back to SQL Server using
autogenerated update statements. Very nice!" which sounds like exactly what
I'm looking for, but searching for more information on "XmlAdapter" just
brings up a bunch of FoxPro stuff. Maybe this feature has been renamed in
the almost two years since that blog post - can anyone point me to current
documentation or samples on how to go about this? I can use SQL 2005 if
needed.
Thanks,
Roger
Hi,
This feature of XML adapter which you have been looking for is not available
in SQL server 2005 beta2.
refer to this link for more info.
http://www.aspnetdev.de/ClassReferen...mlAdapter.aspx
Thanks
"Roger W." wrote:

> Hi, I've been digging through online docs to see if SQLXML can do what I'm
> hoping, and articles say it can, but not how...
> My SQL database has regular relational tables, which I'd like to query
> through xpath from a C# app, get the data returned to an XmlDocument (or
> XPathDocument, but not a DataSet, which I found a sample for), use XPath to
> make changes to the XmlDocument, and then commit the changes back to the SQL
> tables.
> The bottom of this page:
> http://blogs.sqlxml.org/bryantlikes/...10/29/200.aspx regarding
> Whidbey features, says "XmlAdapter - like SqlDataAdapter, fills an
> XPathDocument from SQL Server, updates the changes back to SQL Server using
> autogenerated update statements. Very nice!" which sounds like exactly what
> I'm looking for, but searching for more information on "XmlAdapter" just
> brings up a bunch of FoxPro stuff. Maybe this feature has been renamed in
> the almost two years since that blog post - can anyone point me to current
> documentation or samples on how to go about this? I can use SQL 2005 if
> needed.
> Thanks,
> Roger
>
>