Friday, February 24, 2012

Microsoft VBScript Runtime error 800a001c

I was editing my website and added a feature in error. I tried deleting it
all to no avail. Then I began getting the following error message:
Microsoft VBScript runtime error '800a001c'
Out of stack space: 'Val'
/admin/content/pages.asp, line 7
The part in /admin/content/pages.asp, line 7 reads:
For I = 0 To UBound(arrArray)
If Val(arrArray(I)) = Val(varValue) Then
Array_Exists = True
Exit Function
End If
Next
Array_Exists = False
End Function
I have no idea what to do about it. Any hint or link to the right direction
will be appreciated.
Thanks.Answered elseewhere. Pick a more appropriate NG and don't post the same
message independently to multiple newsgroups.

Microsoft VBScript runtime error

Hello,

I am currently getting the following error:

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'QueryString'

/admin/equipment/addequipment.asp, line 128

This is when i try to submit a new database item in Dreamweaver. The DB I am using is SQL Server 2005.

My code is as follows:

Dim equipspec__urlid
equipspec__urlid = "1"
If (QueryString("ID") <> "") Then
equipspec__urlid = QueryString("ID")
End If
%>
<%
Dim equipspec
Dim equipspec_numRows

Set equipspec = Server.CreateObject("ADODB.Recordset")
equipspec.ActiveConnection = MM_intranet_STRING
equipspec.Source = "SELECT * FROM EquipSpec WHERE " + Replace(equipspec__urlid, "'", "''") + " = EquipSpec.ID"
equipspec.CursorType = 0
equipspec.CursorLocation = 2
equipspec.LockType = 1
equipspec.Open()

Would be greatful if anybody could help, let me know if you need more info.

Many thanks.This is not a TSQL issue. You have a type mismatch in your VB code. The error message contains the line in your source code so check that to see the problem.

Microsoft user group

Sorry for this post but can anyone direct me to Windows XP
Home edition user group ? I Think I locked myself out of
my computer unless Installing SP2 messed me up which is
not installed at all......
Thanks.....
Users group or newsgroup?
For newsgroups, try:
microsoft.public.windowsxp.help_and_support
-Sue
On Mon, 15 Nov 2004 11:20:44 -0800, "Dan"
<anonymous@.discussions.microsoft.com> wrote:

>Sorry for this post but can anyone direct me to Windows XP
>Home edition user group ? I Think I locked myself out of
>my computer unless Installing SP2 messed me up which is
>not installed at all......
>Thanks.....

Microsoft user group

Sorry for this post but can anyone direct me to Windows XP
Home edition user group ? I Think I locked myself out of
my computer unless Installing SP2 messed me up which is
not installed at all......
Thanks.....
"Dan" <anonymous@.discussions.microsoft.com> wrote in news:5be201c4cb48
$325c2540$a401280a@.phx.gbl:

> Sorry for this post but can anyone direct me to Windows XP
> Home edition user group ? I Think I locked myself out of
> my computer unless Installing SP2 messed me up which is
> not installed at all......
> Thanks.....
>
alt.os.windows-xp

Microsoft user group

Sorry for this post but can anyone direct me to Windows XP
Home edition user group ' I Think I locked myself out of
my computer unless Installing SP2 messed me up which is
not installed at all......
Thanks....."Dan" <anonymous@.discussions.microsoft.com> wrote in news:5be201c4cb48
$325c2540$a401280a@.phx.gbl:

> Sorry for this post but can anyone direct me to Windows XP
> Home edition user group ' I Think I locked myself out of
> my computer unless Installing SP2 messed me up which is
> not installed at all......
> Thanks.....
>
alt.os.windows-xp

Microsoft user group

Sorry for this post but can anyone direct me to Windows XP
Home edition user group ' I Think I locked myself out of
my computer unless Installing SP2 messed me up which is
not installed at all......
Thanks.....Sorry for the double post......
>--Original Message--
>Sorry for this post but can anyone direct me to Windows
XP
>Home edition user group ' I Think I locked myself out of
>my computer unless Installing SP2 messed me up which is
>not installed at all......
>Thanks.....
>.
>|||Users group or newsgroup?
For newsgroups, try:
microsoft.public.windowsxp.help_and_support
-Sue
On Mon, 15 Nov 2004 11:20:44 -0800, "Dan"
<anonymous@.discussions.microsoft.com> wrote:
>Sorry for this post but can anyone direct me to Windows XP
>Home edition user group ' I Think I locked myself out of
>my computer unless Installing SP2 messed me up which is
>not installed at all......
>Thanks.....

Microsoft user group

Sorry for this post but can anyone direct me to Windows XP
Home edition user group ' I Think I locked myself out of
my computer unless Installing SP2 messed me up which is
not installed at all......
Thanks....."Dan" <anonymous@.discussions.microsoft.com> wrote in news:5be201c4cb48
$325c2540$a401280a@.phx.gbl:
> Sorry for this post but can anyone direct me to Windows XP
> Home edition user group ' I Think I locked myself out of
> my computer unless Installing SP2 messed me up which is
> not installed at all......
> Thanks.....
>
alt.os.windows-xp

Microsoft Update & SP1

Hi,
I recently upgraded to SQL Server 2005 SP1 (developer edition) on WinXP Pro
+ SP2 by using the Microsoft Update service.
No issues were noted during the upgrade process, and EXEC master..xp_msver
returns 9.00.2047.00 in the ProductVersion column.
However, subsequent running of Microsoft Update still shows SQL Server 2005
SP1 (KB913090) as needing to be installed.
Is this a bug with Microsoft Update, or does it mean that SP1 isn't
installed properly?
Any assistance gratefully received.
MarkHi Mark
It looks like you are on SP1 on that instance! Do you have multiple
instances on this machine? Did you check the installation's log files
(hopefully this is going to be in the same place as a manual installation!).
Have you rebooted since the upgrade?
If you are confident that it is upgraded then you could choose the option to
not show the update again when the update details are expanded.
John
"Mark Rae" wrote:

> Hi,
> I recently upgraded to SQL Server 2005 SP1 (developer edition) on WinXP Pr
o
> + SP2 by using the Microsoft Update service.
> No issues were noted during the upgrade process, and EXEC master..xp_msver
> returns 9.00.2047.00 in the ProductVersion column.
> However, subsequent running of Microsoft Update still shows SQL Server 200
5
> SP1 (KB913090) as needing to be installed.
> Is this a bug with Microsoft Update, or does it mean that SP1 isn't
> installed properly?
> Any assistance gratefully received.
> Mark
>
>|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:34B375F1-9334-4141-B282-2FB06C8D4A44@.microsoft.com...

> Do you have multiple instances on this machine?
No.

> Did you check the installation's log files (hopefully this is going to be
> in the same place as a manual installation!).
Yes.

> Have you rebooted since the upgrade?
Yes. And reapplied the upgrade. And rebooted after that.

> If you are confident that it is upgraded
I'm as confident as I can be, I suppose. Other than master..xp_msver /
SELECT @.@.VERSION, is there anything else I can try...?

> then you could choose the option to not show the update again
> when the update details are expanded.
Yes, but I was loathe to do that until I'd at least asked in here. I've done
a Google search, and there doesn't seem to be anything about this specific
issue. Lots about SP1, of course, but nothing relating to problems with
applying it through Microsoft Update.
I should receive SP1 on DVD any day now as part of my MSDN Universal
subscription, so I'll reinstall it from that and then remove the option from
Microsoft Update if that doesn't fix it.

Microsoft Update & SP1

Hi,
I recently upgraded to SQL Server 2005 SP1 (developer edition) on WinXP Pro
+ SP2 by using the Microsoft Update service.
No issues were noted during the upgrade process, and EXEC master..xp_msver
returns 9.00.2047.00 in the ProductVersion column.
However, subsequent running of Microsoft Update still shows SQL Server 2005
SP1 (KB913090) as needing to be installed.
Is this a bug with Microsoft Update, or does it mean that SP1 isn't
installed properly?
Any assistance gratefully received.
MarkHi Mark
It looks like you are on SP1 on that instance! Do you have multiple
instances on this machine? Did you check the installation's log files
(hopefully this is going to be in the same place as a manual installation!).
Have you rebooted since the upgrade?
If you are confident that it is upgraded then you could choose the option to
not show the update again when the update details are expanded.
John
"Mark Rae" wrote:
> Hi,
> I recently upgraded to SQL Server 2005 SP1 (developer edition) on WinXP Pro
> + SP2 by using the Microsoft Update service.
> No issues were noted during the upgrade process, and EXEC master..xp_msver
> returns 9.00.2047.00 in the ProductVersion column.
> However, subsequent running of Microsoft Update still shows SQL Server 2005
> SP1 (KB913090) as needing to be installed.
> Is this a bug with Microsoft Update, or does it mean that SP1 isn't
> installed properly?
> Any assistance gratefully received.
> Mark
>
>|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:34B375F1-9334-4141-B282-2FB06C8D4A44@.microsoft.com...
> Do you have multiple instances on this machine?
No.
> Did you check the installation's log files (hopefully this is going to be
> in the same place as a manual installation!).
Yes.
> Have you rebooted since the upgrade?
Yes. And reapplied the upgrade. And rebooted after that.
> If you are confident that it is upgraded
I'm as confident as I can be, I suppose. Other than master..xp_msver /
SELECT @.@.VERSION, is there anything else I can try...?
> then you could choose the option to not show the update again
> when the update details are expanded.
Yes, but I was loathe to do that until I'd at least asked in here. I've done
a Google search, and there doesn't seem to be anything about this specific
issue. Lots about SP1, of course, but nothing relating to problems with
applying it through Microsoft Update.
I should receive SP1 on DVD any day now as part of my MSDN Universal
subscription, so I'll reinstall it from that and then remove the option from
Microsoft Update if that doesn't fix it.

Microsoft Technical support

Hi
Can anyone tell me how can I contact the microsoft technical support for a few of my queries?
Thanks
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.Check http://support.microsoft.com/default.aspx?pr=cntactms&style=home.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:B96293D6-9FD0-48E7-A3B4-5DCCD0871046@.microsoft.com...
> Post your queries here. The MSFT RS team answers most of the questions.
> "SqlJunkies User" wrote:
> > Hi
> >
> > Can anyone tell me how can I contact the microsoft technical support for
a few of my queries?
> >
> > Thanks
> >
> >
> > --
> > Posted using Wimdows.net NntpNews Component -
> >
> > Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
> >|||It was suggested previously that this newsgroup may become a "Managed Newsgroup" - any progress on that front?
Regards
Chris McGuigan
"Ravi Mumulla (Microsoft)" wrote:
> Check http://support.microsoft.com/default.aspx?pr=cntactms&style=home.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
> news:B96293D6-9FD0-48E7-A3B4-5DCCD0871046@.microsoft.com...
> > Post your queries here. The MSFT RS team answers most of the questions.
> >
> > "SqlJunkies User" wrote:
> >
> > > Hi
> > >
> > > Can anyone tell me how can I contact the microsoft technical support for
> a few of my queries?
> > >
> > > Thanks
> > >
> > >
> > > --
> > > Posted using Wimdows.net NntpNews Component -
> > >
> > > Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
> supports Post Alerts, Ratings, and Searching.
> > >
>
>|||Last I heard, they were going to give it another 30 days to get more data.
That would be around the beginning of July. Once they have all the data they
need, I have no idea how long it will take them to make the decision and get
the contracts in place. I'm hoping it'll be fairly soon but I don't have
direct visibility into that process.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris McGuigan" <ChrisMcGuigan@.discussions.microsoft.com> wrote in message
news:1DE126C2-959F-4D53-88B8-4D8AE43A19EB@.microsoft.com...
> It was suggested previously that this newsgroup may become a "Managed
Newsgroup" - any progress on that front?
> Regards
> Chris McGuigan
> "Ravi Mumulla (Microsoft)" wrote:
> > Check http://support.microsoft.com/default.aspx?pr=cntactms&style=home.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
> > news:B96293D6-9FD0-48E7-A3B4-5DCCD0871046@.microsoft.com...
> > > Post your queries here. The MSFT RS team answers most of the
questions.
> > >
> > > "SqlJunkies User" wrote:
> > >
> > > > Hi
> > > >
> > > > Can anyone tell me how can I contact the microsoft technical support
for
> > a few of my queries?
> > > >
> > > > Thanks
> > > >
> > > >
> > > > --
> > > > Posted using Wimdows.net NntpNews Component -
> > > >
> > > > Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup
engine
> > supports Post Alerts, Ratings, and Searching.
> > > >
> >
> >
> >|||Thanks for the update Stephen.
Regards
Chris McGuigan
"Stephen Dybing [MSFT]" wrote:
> Last I heard, they were going to give it another 30 days to get more data.
> That would be around the beginning of July. Once they have all the data they
> need, I have no idea how long it will take them to make the decision and get
> the contracts in place. I'm hoping it'll be fairly soon but I don't have
> direct visibility into that process.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Chris McGuigan" <ChrisMcGuigan@.discussions.microsoft.com> wrote in message
> news:1DE126C2-959F-4D53-88B8-4D8AE43A19EB@.microsoft.com...
> > It was suggested previously that this newsgroup may become a "Managed
> Newsgroup" - any progress on that front?
> >
> > Regards
> > Chris McGuigan
> >
> > "Ravi Mumulla (Microsoft)" wrote:
> >
> > > Check http://support.microsoft.com/default.aspx?pr=cntactms&style=home.
> > >
> > > --
> > > Ravi Mumulla (Microsoft)
> > > SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > "Jeff" <Jeff@.discussions.microsoft.com> wrote in message
> > > news:B96293D6-9FD0-48E7-A3B4-5DCCD0871046@.microsoft.com...
> > > > Post your queries here. The MSFT RS team answers most of the
> questions.
> > > >
> > > > "SqlJunkies User" wrote:
> > > >
> > > > > Hi
> > > > >
> > > > > Can anyone tell me how can I contact the microsoft technical support
> for
> > > a few of my queries?
> > > > >
> > > > > Thanks
> > > > >
> > > > >
> > > > > --
> > > > > Posted using Wimdows.net NntpNews Component -
> > > > >
> > > > > Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup
> engine
> > > supports Post Alerts, Ratings, and Searching.
> > > > >
> > >
> > >
> > >
>
>

Microsoft Takes the Fight Against Cybercrime Worldwide (eBay Fraud/Phishing)

eBay Fraudsters and Phishers are being taken on by Bill and friends.
[url]http://fraudwar.blogspot.com/2006/03/microsoft-takes-fight-against-cyber.html[/url
]Like everything else in IT; other companies may have pioneered the internet,
but it's Microsoft who civilized it.
<tedrichardson9925@.sbcglobal.net> wrote in message
news:1142957243.156477.129410@.u72g2000cwu.googlegroups.com...
> eBay Fraudsters and Phishers are being taken on by Bill and friends.
> [url]http://fraudwar.blogspot.com/2006/03/microsoft-takes-fight-against-cyber.html[/u
rl]
>|||On Tue, 21 Mar 2006 11:42:52 -0500, "JT" <someone@.microsoft.com> wrote:
in <eHLTGcQTGHA.4792@.TK2MSFTNGP14.phx.gbl>

>Like everything else in IT; other companies may have pioneered the internet
,
>but it's Microsoft who civilized it.
Certainly not with all their ~innovation~ ?
This posting is provided "AS IS" with no warranties, no guarantees, and no c
onferred rights.
Stefan Berglund|||In the beginning, the web was nothing but term papers, e-mail, and dorky
personal web pages; it wasn't until Microsoft came into the picture that
e-commerce, professional corporate portals, and truely interactive content
came into full bloom. Were it not for Bill Gates, the general public today
wouldn't know or even care about the internet. Try contrasting Visual
Studio.NET or the business intelligence features bundled with SQL Server
2005 with any other competing development platform (haaa!). When it comes to
office productivity tools, MS Office is the standard that everyone else
tries (and fails) to immitate.
"Stefan Berglund" <sorry.no.koolaid@.for.me> wrote in message
news:32e022pnia8iq9kgl7f0615dtcbqb905v3@.
4ax.com...
> On Tue, 21 Mar 2006 11:42:52 -0500, "JT" <someone@.microsoft.com> wrote:
> in <eHLTGcQTGHA.4792@.TK2MSFTNGP14.phx.gbl>
>
> Certainly not with all their ~innovation~ ?
> --
> This posting is provided "AS IS" with no warranties, no guarantees, and no
> conferred rights.
> Stefan Berglund

Microsoft table design best practices

I remember viewing a Microsoft article (MSDN, i think) that gave a detailed
list of Microsoft's best practices for designing database tables. It
mentioned stuff like naming conventions, etc. but I'll be damned if I can
find it again.
Has anyone seen this article?bshewan wrote:
> I remember viewing a Microsoft article (MSDN, i think) that gave a
> detailed list of Microsoft's best practices for designing database
> tables. It mentioned stuff like naming conventions, etc. but I'll be
> damned if I can find it again.
> Has anyone seen this article?
Not from MS, but may give you some ideas:
http://vyaskn.tripod.com/object_naming.htm
David Gugick
Quest Software
www.imceda.com
www.quest.com

Microsoft Support to MSDE

Hi ,

Does microsoft supports MSDE still or it will support only Sql 2005 Express edition.

Hi,

see: http://blogs.msdn.com/sqlexpress/archive/2006/08/09/693650.aspx

· MSDE 2000 s almost at the end of it's support life cycle - MSDE 2000 will exit mainstream support on 4/8/2008 and no new deployment agreements will be allowed after June 30, 2007.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Microsoft Support for SQL Server 2000

Hello,
I would like to see if Microsoft has issued any announcement on SQL Server 2000 end of support. If anyone is aware of this or seen new posts/articles, please let me know.
Thank you!

MS official Lifecycle support for SQL 2000 is posted here: http://support.microsoft.com/lifecycle/?p1=2852

Thanks,

AWAL

Microsoft SSMSE - Printing database layout?

I'm connected to my remote SQL 2000 server using Microsofts SQL Server
Management Studio Express.
I can't see any way to print out my database table properties. Under
Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
which does not work.
How does one print out the layout of their database from this app?
Thanks!Noozer
Do you want to print a diagram by using SSMS of the SQL Server 2000
database?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
> Management Studio Express.
> I can't see any way to print out my database table properties. Under
> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
> which does not work.
> How does one print out the layout of their database from this app?
> Thanks!
>|||Diagrams would be great!
But, I'd settle for simply printing the properties from each of my tables.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
> Noozer
> Do you want to print a diagram by using SSMS of the SQL Server 2000
> database?
>
>
> "Noozer" <dont.spam@.me.here> wrote in message
> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
>> which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>|||Noozer
What properties? There is an option Script Table As , are you talking about
this feature?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Diagrams would be great!
> But, I'd settle for simply printing the properties from each of my tables.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>> Noozer
>> Do you want to print a diagram by using SSMS of the SQL Server 2000
>> database?
>>
>>
>> "Noozer" <dont.spam@.me.here> wrote in message
>> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
>> which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>>
>|||Why can't you go to File, Print...
or right-click the db diagram, "Copy Diagram to Clipboard," and paste/print
from Word?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Diagrams would be great!
> But, I'd settle for simply printing the properties from each of my tables.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>> Noozer
>> Do you want to print a diagram by using SSMS of the SQL Server 2000
>> database?
>>
>>
>> "Noozer" <dont.spam@.me.here> wrote in message
>> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
>> which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>>
>|||Because "Print..." is coming up disabled.
The server is a remote MS SQL 2000 server.
Diagrams does not work at all.
"JFoushee" <someone@.somewhere-donotspam.com> wrote in message
news:O$O9PTRbGHA.4116@.TK2MSFTNGP05.phx.gbl...
> Why can't you go to File, Print...
> or right-click the db diagram, "Copy Diagram to Clipboard," and
> paste/print from Word?
> "Noozer" <dont.spam@.me.here> wrote in message
> news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
>> Diagrams would be great!
>> But, I'd settle for simply printing the properties from each of my
>> tables.
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>> Noozer
>> Do you want to print a diagram by using SSMS of the SQL Server 2000
>> database?
>>
>>
>> "Noozer" <dont.spam@.me.here> wrote in message
>> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
>> Management Studio Express.
>> I can't see any way to print out my database table properties. Under
>> Database Diagrams all I have is "Working with SQL Server 2000
>> Diagrams", which does not work.
>> How does one print out the layout of their database from this app?
>> Thanks!
>>
>>
>

Microsoft SSMSE - Printing database layout?

I'm connected to my remote SQL 2000 server using Microsofts SQL Server
Management Studio Express.
I can't see any way to print out my database table properties. Under
Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
which does not work.
How does one print out the layout of their database from this app?
Thanks!Noozer
Do you want to print a diagram by using SSMS of the SQL Server 2000
database?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
> I'm connected to my remote SQL 2000 server using Microsofts SQL Server
> Management Studio Express.
> I can't see any way to print out my database table properties. Under
> Database Diagrams all I have is "Working with SQL Server 2000 Diagrams",
> which does not work.
> How does one print out the layout of their database from this app?
> Thanks!
>|||Diagrams would be great!
But, I'd settle for simply printing the properties from each of my tables.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
> Noozer
> Do you want to print a diagram by using SSMS of the SQL Server 2000
> database?
>
>
> "Noozer" <dont.spam@.me.here> wrote in message
> news:%23S4naZ$ZGHA.4060@.TK2MSFTNGP02.phx.gbl...
>|||Noozer
What properties? There is an option Script Table As , are you talking about
this feature?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Diagrams would be great!
> But, I'd settle for simply printing the properties from each of my tables.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>|||Why can't you go to File, Print...
or right-click the db diagram, "Copy Diagram to Clipboard," and paste/print
from Word?
"Noozer" <dont.spam@.me.here> wrote in message
news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Diagrams would be great!
> But, I'd settle for simply printing the properties from each of my tables.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23$oEp0CaGHA.4292@.TK2MSFTNGP02.phx.gbl...
>|||Because "Print..." is coming up disabled.
The server is a remote MS SQL 2000 server.
Diagrams does not work at all.
"JFoushee" <someone@.somewhere-donotspam.com> wrote in message
news:O$O9PTRbGHA.4116@.TK2MSFTNGP05.phx.gbl...
> Why can't you go to File, Print...
> or right-click the db diagram, "Copy Diagram to Clipboard," and
> paste/print from Word?
> "Noozer" <dont.spam@.me.here> wrote in message
> news:%23EuOR6CaGHA.1192@.TK2MSFTNGP03.phx.gbl...
>

Microsoft SQLXML Bulkload 4.0 Type Library with SQL Express

Hello,

I'm trying to follow a sample from microsoft for Using SQLXML Bulk Load in the .NET Environment

In the sample c# console app. it says to select add reference then In theCOM tab, selectMicrosoft SQLXML Bulkload 4.0 Type Library (xblkld4.dll) and clickOK.

The problem I have is I cannot find the library or the xblkd4.dll file on my pc.

Does anyone have any suggestions? Any help would be much appreicated.

Thanks

Karl

Hi,

From your description, it seems that you are unable to import the Microsoft SQLXML BulkLoad 4.0 type library, right?

Based on my understanding, XML Bulk Load is a standalone COM object that allows you to load semistructured XML data into Microsoft SQL Server tables. So before you are going to add the library, make sure that you have installed Microsoft SQL Server (i.e Microsoft SQLServer2005) product.

Thanks.

|||

I have the same problem. I have SQL Server 2005 with notification services installed locally and am using v2.0 of the frameworks and Team edition VS.Net 2005 SP1 and am working in C#. I have install SQLXML v4 and have located the dll next to the v3 dll which is listed as a COM object in the reference listing of COMs.

Any help on what steps to take to install so the library shows up in the COM listing would be appreciated.

Edwin

|||

I found a good article on this.

http://64.233.169.104/search?q=cache:jsAQOib9cFoJ:wijix.com/blogs/centricity/archive/2007/04/30/bulk-loading-xml-into-sql-server-2005-using-net.aspx+SQLXMLBulkLoad+Visual+studio+2005+reference&hl=en&ct=clnk&cd=2&gl=us

|||

The link was extremely helpful. Thanks.

Microsoft SqlServer Desktop Engine Connection Problem

i installed the MSDE2000A on server and i tried to connect from client machine through vb Application using connection string. Server anad client are in LAN. but Some systems able to connect and some systems are unable to connect.

i am getting the error:

"SqlServer does not exist or access denied "

for non connected machines.

the server is listening from these machines. but not connecting to MSDE.

can anyone give me solution what may be the cause.Ensure the System DSN used and login must have required privileges to connect to SQL server.

What is the authentication mode used?

Try:
1. Make sure the SQL server is on
2. Ping the server machine
3. Try connecting to the IP address rather than the server name

Review information from this KBA (http://support.microsoft.com/default.aspx?scid=kb;en-us;328306) for potential causes and resolve it.|||i am using user authentication mode.
i have set DISABLENETWORKPROTOCOLS=0
i have done pinging through IP Address.
i am able ping database.
after doing all these test .. still getting same error...

is there any other possibilities....

Originally posted by Satya
Ensure the System DSN used and login must have required privileges to connect to SQL server.

What is the authentication mode used?

Try:
1. Make sure the SQL server is on
2. Ping the server machine
3. Try connecting to the IP address rather than the server name

Review information from this KBA (http://support.microsoft.com/default.aspx?scid=kb;en-us;328306) for potential causes and resolve it.|||Review points listed in the knowledgebase article.

i am using user authentication mode.
SQL Server does have only 2 modes - Windows only or mixed. Which on e is yours?

i have set DISABLENETWORKPROTOCOLS=0
Don't know about this protocol in SQL, it should be named-pipes, TCP/ip or Multi-protocol. From Start--> programs --> goto MSSQLServer program group and select Server network utility and check for enabled protocols.
i am able ping database.
How can you do that in SQL?|||mine is MIXEDMODE.

this is obtained by setting parameter SECURITYMODE=SQL

i am sorry to tell u that i ping to database.

not database... it is server.

i am able to ping to server where i installed MSDE.

Originally posted by Satya
Review points listed in the knowledgebase article.

SQL Server does have only 2 modes - Windows only or mixed. Which on e is yours?

Don't know about this protocol in SQL, it should be named-pipes, TCP/ip or Multi-protocol. From Start--> programs --> goto MSSQLServer program group and select Server network utility and check for enabled protocols.

How can you do that in SQL?|||I'm probably being silly, but could you have installed SQL as a named server and tried to access it as a default (unnamed) server?

-PatP|||Check for any h/w issues on server installed by referring to event viewer log.

microsoft SQLServer CE

hi all..
just wondering that:
microsoft SQLServer = microsoft SQLServer CE?
how to use the microsoft SQLServer CE?
isiz the microsoft SQLServer CE can be used on the
microsoft SQLServer?
i really doubt abt this..hope someone can help me!!
thanks...CE is for embedded applications (for devices), and will have different features etc...

Microsoft SQL-DMO(ODBC SQLState:42000)

I am getting the following error message in SQL 2K when I try to give
database access to a login Id "LogInId1".
****************************************
*************
Microsoft SQL-DMO(ODBC SQLState:42000)
Error 15023: User or role 'LogInId1' already exists in the current database.
****************************************
************************************
*
The "public" role in the above "current database" has a user Id "LogInId1".
This is the one it is generating the above error message. I can not remove
the above user ID from that role (public).
What I did to generate the above error message?
I restored one user database on SQL 2K (running under windows 2003) from the
backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
database from which back was ran.
How to add database access permissions to the login Id ""LogInId1"?
Thank you,
SmithYou can try:
exec sp_changedbowner 'LogInId1'
"John Smith" wrote:

> I am getting the following error message in SQL 2K when I try to give
> database access to a login Id "LogInId1".
>
> ****************************************
*************
> Microsoft SQL-DMO(ODBC SQLState:42000)
> Error 15023: User or role 'LogInId1' already exists in the current databas
e.
> ****************************************
**********************************
**
> *
>
> The "public" role in the above "current database" has a user Id "LogInId1"
.
> This is the one it is generating the above error message. I can not remove
> the above user ID from that role (public).
>
> What I did to generate the above error message?
> I restored one user database on SQL 2K (running under windows 2003) from t
he
> backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
> database from which back was ran.
>
> How to add database access permissions to the login Id ""LogInId1"?
> Thank you,
> Smith
>
>
>|||Take a look at sp_resolve_logins in BOL, etc.
The internal (to the database) user tables have entries that are either not
in the Master SYSLOGINS table or have different pointers to that table. You
need to either repoint(resolve) or remove those logins.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Fahim" wrote:
[vbcol=seagreen]
> You can try:
> exec sp_changedbowner 'LogInId1'
>
> "John Smith" wrote:
>

Microsoft SQL-DMO(ODBC SQLState:42000)

I am getting the following error message in SQL 2K when I try to give
database access to a login Id "LogInId1".
*****************************************************
Microsoft SQL-DMO(ODBC SQLState:42000)
Error 15023: User or role 'LogInId1' already exists in the current database.
****************************************************************************
*
The "public" role in the above "current database" has a user Id "LogInId1".
This is the one it is generating the above error message. I can not remove
the above user ID from that role (public).
What I did to generate the above error message?
I restored one user database on SQL 2K (running under windows 2003) from the
backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
database from which back was ran.
How to add database access permissions to the login Id ""LogInId1"?
Thank you,
SmithYou can try:
exec sp_changedbowner 'LogInId1'
"John Smith" wrote:
> I am getting the following error message in SQL 2K when I try to give
> database access to a login Id "LogInId1".
>
> *****************************************************
> Microsoft SQL-DMO(ODBC SQLState:42000)
> Error 15023: User or role 'LogInId1' already exists in the current database.
> ****************************************************************************
> *
>
> The "public" role in the above "current database" has a user Id "LogInId1".
> This is the one it is generating the above error message. I can not remove
> the above user ID from that role (public).
>
> What I did to generate the above error message?
> I restored one user database on SQL 2K (running under windows 2003) from the
> backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
> database from which back was ran.
>
> How to add database access permissions to the login Id ""LogInId1"?
> Thank you,
> Smith
>
>
>|||Take a look at sp_resolve_logins in BOL, etc.
The internal (to the database) user tables have entries that are either not
in the Master SYSLOGINS table or have different pointers to that table. You
need to either repoint(resolve) or remove those logins.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Fahim" wrote:
> You can try:
> exec sp_changedbowner 'LogInId1'
>
> "John Smith" wrote:
> > I am getting the following error message in SQL 2K when I try to give
> > database access to a login Id "LogInId1".
> >
> >
> >
> > *****************************************************
> >
> > Microsoft SQL-DMO(ODBC SQLState:42000)
> >
> > Error 15023: User or role 'LogInId1' already exists in the current database.
> >
> > ****************************************************************************
> > *
> >
> >
> >
> > The "public" role in the above "current database" has a user Id "LogInId1".
> > This is the one it is generating the above error message. I can not remove
> > the above user ID from that role (public).
> >
> >
> >
> > What I did to generate the above error message?
> >
> > I restored one user database on SQL 2K (running under windows 2003) from the
> > backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
> > database from which back was ran.
> >
> >
> >
> > How to add database access permissions to the login Id ""LogInId1"?
> >
> > Thank you,
> >
> > Smith
> >
> >
> >
> >
> >

Microsoft SQL-DMO(ODBC SQLState:42000)

I am getting the following error message in SQL 2K when I try to give
database access to a login Id "LogInId1".
************************************************** ***
Microsoft SQL-DMO(ODBC SQLState:42000)
Error 15023: User or role 'LogInId1' already exists in the current database.
************************************************** **************************
*
The "public" role in the above "current database" has a user Id "LogInId1".
This is the one it is generating the above error message. I can not remove
the above user ID from that role (public).
What I did to generate the above error message?
I restored one user database on SQL 2K (running under windows 2003) from the
backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
database from which back was ran.
How to add database access permissions to the login Id ""LogInId1"?
Thank you,
Smith
You can try:
exec sp_changedbowner 'LogInId1'
"John Smith" wrote:

> I am getting the following error message in SQL 2K when I try to give
> database access to a login Id "LogInId1".
>
> ************************************************** ***
> Microsoft SQL-DMO(ODBC SQLState:42000)
> Error 15023: User or role 'LogInId1' already exists in the current database.
> ************************************************** **************************
> *
>
> The "public" role in the above "current database" has a user Id "LogInId1".
> This is the one it is generating the above error message. I can not remove
> the above user ID from that role (public).
>
> What I did to generate the above error message?
> I restored one user database on SQL 2K (running under windows 2003) from the
> backup of SQL2K running under Win2K. The user Id "LogInId1" existed in the
> database from which back was ran.
>
> How to add database access permissions to the login Id ""LogInId1"?
> Thank you,
> Smith
>
>
>
|||Take a look at sp_resolve_logins in BOL, etc.
The internal (to the database) user tables have entries that are either not
in the Master SYSLOGINS table or have different pointers to that table. You
need to either repoint(resolve) or remove those logins.
Joseph R.P. Maloney, CSP,CCP,CDP
"Fahim" wrote:
[vbcol=seagreen]
> You can try:
> exec sp_changedbowner 'LogInId1'
>
> "John Smith" wrote:

Microsoft SQL-DMO [SQL-DMO]Out of memory error

Hi,
We have a stored procedure that we call very frequently
that polls servers to see if they are available. This is
used from various other stored procedures that may then
use an available SQL Server or try another one.
We have implemented the stored procedure such that it uses
the SP_OA routines to perform a SQL-DMO connect. This
works very well and allows us to catch the 'server
unavailable' error in stored procedure code and branch.
Unfortunataly, if the SQL Server that issues the connect
has not been restarted for a few says we get the following
message back from the connect method (from
sp_OAGetErrorInfo):
0x80045900 Microsoft SQL-DMO [SQL-DMO]Out of
memory.
I have included the code fragment below we are using. Has
anyone any thoughts, please, on where our memory leak is
happening. All our SQL Servers are SP2 currently.
Many thanks, Ken
---
CREATE PROCEDURE xxx @.ServerName VARCHAR(20),
@.LoginTimeout INT = 10
AS
SET NOCOUNT ON
DECLARE @.iRet int
DECLARE @.object int
DECLARE @.hr int
DECLARE @.src varchar(255), @.desc varchar(255)
-- @.iRet - return value of procedures
-- @.object - object reference
-- @.hr - handle
-- @.src - source of error message
-- @.desc - description of error message
-- Set up parameters/variables
SELECT @.iRet = 0, @.hr = 0, @.object = 0
-- create SQLDMO SQLServer object
EXEC @.hr = sp_OACreate 'SQLDMO.SQLServer', @.object OUT
IF @.hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @.object, @.src OUT,
@.desc OUT
SELECT hr=convert(varbinary(4),@.hr),
Source=@.src, Description=@.desc
RETURN (2)
END
-- Set the properties
-- Set the LoginTimeout property.
EXEC @.hr = sp_OASetProperty @.object, 'LoginTimeout',
@.LoginTimeout
IF @.hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @.object, @.src OUT, @.desc
OUT
SELECT hr=convert(varbinary(4),@.hr), Source=@.src,
Description=@.desc
EXEC @.hr = sp_OADestroy @.object
RETURN (3)
END
-- Set the integrated login property.
EXEC @.hr = sp_OASetProperty @.object,'LoginSecure',1
IF @.hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @.object, @.src OUT, @.desc
OUT
SELECT hr=convert(varbinary(4),@.hr), Source=@.src,
Description=@.desc
EXEC @.hr = sp_OADestroy @.object
RETURN (4)
END
-- attempt to connect to server
EXEC @.hr = sp_OAMethod @.object, 'Connect', NULL,
@.ServerName
IF @.hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @.object, @.src OUT, @.desc
OUT
SELECT hr=convert(varbinary(4),@.hr), Source=@.src,
Description=@.desc
SELECT @.iRet = convert(varbinary(4),@.hr)
EXEC @.hr = sp_OADestroy @.object
RETURN (CASE @.iRet WHEN 0x80020009 THEN 2 ELSE 1
END) -- 2 = 'SQL Server does not exist or access denied',
1 = misc. error
END
-- Disconnect
EXEC @.hr = sp_OAMethod @.object, 'DisConnect'
IF @.hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @.object, @.src OUT, @.desc
OUT
SELECT hr=convert(varbinary(4),@.hr),
Source=@.src, Description=@.desc
EXEC @.hr = sp_OADestroy @.object
RETURN (5)
END
-- Destroy object
EXEC @.hr = sp_OADestroy @.object
IF @.hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @.object, @.src OUT, @.desc
OUT
SELECT hr=convert(varbinary(4),@.hr), Source=@.src,
Description=@.desc
RETURN (6)
END
-- success
RETURN (0)
GOIt's difficult to trace memory leaks like this. I can't help with the DMO
specific troubleshooting, but... I would encourage to you to review the fix
list for SP3a. I remember reading about some memory leak issues, don't
remember what they were... but you don't want to waste time on a fix in the
latest SP.
Also... do you have an ability to either a) rollout SP3 (which you really
should anyway for security purposes) or b) at least roll it out in a QA
envrionment where you can test this memory leak against Sp3. That might save
you a lot of time...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Ken Eng" <keneng23@.hotmail.com> wrote in message
news:0d5001c36e33$069fcfb0$a301280a@.phx.gbl...
> Hi,
> We have a stored procedure that we call very frequently
> that polls servers to see if they are available. This is
> used from various other stored procedures that may then
> use an available SQL Server or try another one.
> We have implemented the stored procedure such that it uses
> the SP_OA routines to perform a SQL-DMO connect. This
> works very well and allows us to catch the 'server
> unavailable' error in stored procedure code and branch.
> Unfortunataly, if the SQL Server that issues the connect
> has not been restarted for a few says we get the following
> message back from the connect method (from
> sp_OAGetErrorInfo):
> 0x80045900 Microsoft SQL-DMO [SQL-DMO]Out of
> memory.
> I have included the code fragment below we are using. Has
> anyone any thoughts, please, on where our memory leak is
> happening. All our SQL Servers are SP2 currently.
>
> Many thanks, Ken
> ---
> CREATE PROCEDURE xxx @.ServerName VARCHAR(20),
> @.LoginTimeout INT = 10
> AS
> SET NOCOUNT ON
>
> DECLARE @.iRet int
> DECLARE @.object int
> DECLARE @.hr int
> DECLARE @.src varchar(255), @.desc varchar(255)
> -- @.iRet - return value of procedures
> -- @.object - object reference
> -- @.hr - handle
> -- @.src - source of error message
> -- @.desc - description of error message
> -- Set up parameters/variables
> SELECT @.iRet = 0, @.hr = 0, @.object = 0
> -- create SQLDMO SQLServer object
> EXEC @.hr = sp_OACreate 'SQLDMO.SQLServer', @.object OUT
> IF @.hr <> 0
> BEGIN
> EXEC sp_OAGetErrorInfo @.object, @.src OUT,
> @.desc OUT
> SELECT hr=convert(varbinary(4),@.hr),
> Source=@.src, Description=@.desc
> RETURN (2)
> END
> -- Set the properties
> -- Set the LoginTimeout property.
> EXEC @.hr = sp_OASetProperty @.object, 'LoginTimeout',
> @.LoginTimeout
> IF @.hr <> 0
> BEGIN
> EXEC sp_OAGetErrorInfo @.object, @.src OUT, @.desc
> OUT
> SELECT hr=convert(varbinary(4),@.hr), Source=@.src,
> Description=@.desc
> EXEC @.hr = sp_OADestroy @.object
> RETURN (3)
> END
>
> -- Set the integrated login property.
> EXEC @.hr = sp_OASetProperty @.object,'LoginSecure',1
> IF @.hr <> 0
> BEGIN
> EXEC sp_OAGetErrorInfo @.object, @.src OUT, @.desc
> OUT
> SELECT hr=convert(varbinary(4),@.hr), Source=@.src,
> Description=@.desc
> EXEC @.hr = sp_OADestroy @.object
> RETURN (4)
> END
> -- attempt to connect to server
> EXEC @.hr = sp_OAMethod @.object, 'Connect', NULL,
> @.ServerName
> IF @.hr <> 0
> BEGIN
> EXEC sp_OAGetErrorInfo @.object, @.src OUT, @.desc
> OUT
> SELECT hr=convert(varbinary(4),@.hr), Source=@.src,
> Description=@.desc
> SELECT @.iRet = convert(varbinary(4),@.hr)
> EXEC @.hr = sp_OADestroy @.object
> RETURN (CASE @.iRet WHEN 0x80020009 THEN 2 ELSE 1
> END) -- 2 = 'SQL Server does not exist or access denied',
> 1 = misc. error
> END
> -- Disconnect
> EXEC @.hr = sp_OAMethod @.object, 'DisConnect'
> IF @.hr <> 0
> BEGIN
> EXEC sp_OAGetErrorInfo @.object, @.src OUT, @.desc
> OUT
> SELECT hr=convert(varbinary(4),@.hr),
> Source=@.src, Description=@.desc
> EXEC @.hr = sp_OADestroy @.object
> RETURN (5)
> END
> -- Destroy object
> EXEC @.hr = sp_OADestroy @.object
> IF @.hr <> 0
> BEGIN
> EXEC sp_OAGetErrorInfo @.object, @.src OUT, @.desc
> OUT
> SELECT hr=convert(varbinary(4),@.hr), Source=@.src,
> Description=@.desc
> RETURN (6)
> END
> -- success
> RETURN (0)
> GO
>
>|||Thanks Brian,
I will move to SP3 to take this out of the equation.
Cheers
Ken
>--Original Message--
>It's difficult to trace memory leaks like this. I can't
help with the DMO
>specific troubleshooting, but... I would encourage to you
to review the fix
>list for SP3a. I remember reading about some memory leak
issues, don't
>remember what they were... but you don't want to waste
time on a fix in the
>latest SP.
>Also... do you have an ability to either a) rollout SP3
(which you really
>should anyway for security purposes) or b) at least roll
it out in a QA
>envrionment where you can test this memory leak against
Sp3. That might save
>you a lot of time...
>--
>Brian Moran
>Principal Mentor
>Solid Quality Learning
>SQL Server MVP
>http://www.solidqualitylearning.com
>
>"Ken Eng" <keneng23@.hotmail.com> wrote in message
>news:0d5001c36e33$069fcfb0$a301280a@.phx.gbl...
>> Hi,
>> We have a stored procedure that we call very frequently
>> that polls servers to see if they are available. This is
>> used from various other stored procedures that may then
>> use an available SQL Server or try another one.
>> We have implemented the stored procedure such that it
uses
>> the SP_OA routines to perform a SQL-DMO connect. This
>> works very well and allows us to catch the 'server
>> unavailable' error in stored procedure code and branch.
>> Unfortunataly, if the SQL Server that issues the connect
>> has not been restarted for a few says we get the
following
>> message back from the connect method (from
>> sp_OAGetErrorInfo):
>> 0x80045900 Microsoft SQL-DMO [SQL-DMO]Out of
>> memory.
>> I have included the code fragment below we are using.
Has
>> anyone any thoughts, please, on where our memory leak is
>> happening. All our SQL Servers are SP2 currently.
>>
>> Many thanks, Ken
>> ---
>> CREATE PROCEDURE xxx @.ServerName VARCHAR(20),
>> @.LoginTimeout INT = 10
>> AS
>> SET NOCOUNT ON
>>
>> DECLARE @.iRet int
>> DECLARE @.object int
>> DECLARE @.hr int
>> DECLARE @.src varchar(255), @.desc varchar(255)
>> -- @.iRet - return value of procedures
>> -- @.object - object reference
>> -- @.hr - handle
>> -- @.src - source of error message
>> -- @.desc - description of error message
>> -- Set up parameters/variables
>> SELECT @.iRet = 0, @.hr = 0, @.object = 0
>> -- create SQLDMO SQLServer object
>> EXEC @.hr = sp_OACreate 'SQLDMO.SQLServer', @.object OUT
>> IF @.hr <> 0
>> BEGIN
>> EXEC sp_OAGetErrorInfo @.object, @.src OUT,
>> @.desc OUT
>> SELECT hr=convert(varbinary(4),@.hr),
>> Source=@.src, Description=@.desc
>> RETURN (2)
>> END
>> -- Set the properties
>> -- Set the LoginTimeout property.
>> EXEC @.hr = sp_OASetProperty @.object, 'LoginTimeout',
>> @.LoginTimeout
>> IF @.hr <> 0
>> BEGIN
>> EXEC sp_OAGetErrorInfo @.object, @.src OUT, @.desc
>> OUT
>> SELECT hr=convert(varbinary(4),@.hr), Source=@.src,
>> Description=@.desc
>> EXEC @.hr = sp_OADestroy @.object
>> RETURN (3)
>> END
>>
>> -- Set the integrated login property.
>> EXEC @.hr = sp_OASetProperty @.object,'LoginSecure',1
>> IF @.hr <> 0
>> BEGIN
>> EXEC sp_OAGetErrorInfo @.object, @.src OUT, @.desc
>> OUT
>> SELECT hr=convert(varbinary(4),@.hr), Source=@.src,
>> Description=@.desc
>> EXEC @.hr = sp_OADestroy @.object
>> RETURN (4)
>> END
>> -- attempt to connect to server
>> EXEC @.hr = sp_OAMethod @.object, 'Connect', NULL,
>> @.ServerName
>> IF @.hr <> 0
>> BEGIN
>> EXEC sp_OAGetErrorInfo @.object, @.src OUT, @.desc
>> OUT
>> SELECT hr=convert(varbinary(4),@.hr), Source=@.src,
>> Description=@.desc
>> SELECT @.iRet = convert(varbinary(4),@.hr)
>> EXEC @.hr = sp_OADestroy @.object
>> RETURN (CASE @.iRet WHEN 0x80020009 THEN 2 ELSE 1
>> END) -- 2 = 'SQL Server does not exist or access
denied',
>> 1 = misc. error
>> END
>> -- Disconnect
>> EXEC @.hr = sp_OAMethod @.object, 'DisConnect'
>> IF @.hr <> 0
>> BEGIN
>> EXEC sp_OAGetErrorInfo @.object, @.src OUT, @.desc
>> OUT
>> SELECT hr=convert(varbinary(4),@.hr),
>> Source=@.src, Description=@.desc
>> EXEC @.hr = sp_OADestroy @.object
>> RETURN (5)
>> END
>> -- Destroy object
>> EXEC @.hr = sp_OADestroy @.object
>> IF @.hr <> 0
>> BEGIN
>> EXEC sp_OAGetErrorInfo @.object, @.src OUT, @.desc
>> OUT
>> SELECT hr=convert(varbinary(4),@.hr), Source=@.src,
>> Description=@.desc
>> RETURN (6)
>> END
>> -- success
>> RETURN (0)
>> GO
>>
>
>.
>

Microsoft SQL-DMO error 7405 on linked server query

I am attempting to execute a query on a linked oracle server. The link
is fine and I can execute the query
from query analyser but when I create the stored procedure I get this
error:
Microsoft SQL-DMO (ODBC SQL State:42000)
Error 7405: Hetergenous queries require the ANSI NULLS and ANSI
WARNINGS
options
to be set for the connection. This ensures consistent query semantics.
Enable
these options and then reissue your query.
I have looked through numerous posting on the subject and still
cannot resolve the issue.
here is the code
CREATE PROCEDURE [DBO].[TEST1] AS
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
GO
select sid from ......
GO
After this I attempted to alter the procdure still with no effect and
finally I issued the sp_configure 'user options',
'32' do set the default and still no luck does anyone have any other
suggestions.Try removing the GO after setting the ANSI NULLS and WARNINGS.|||ehwood@.msn.com (Eric Wood) wrote in message news:<43c03fab.0402191320.27124b8e@.posting.g
oogle.com>...
> I am attempting to execute a query on a linked oracle server. The link
> is fine and I can execute the query
> from query analyser but when I create the stored procedure I get this
> error:
> Microsoft SQL-DMO (ODBC SQL State:42000)
> Error 7405: Hetergenous queries require the ANSI NULLS and ANSI
> WARNINGS
> options
> to be set for the connection. This ensures consistent query semantics.
> Enable
> these options and then reissue your query.
>
> I have looked through numerous posting on the subject and still
> cannot resolve the issue.
> here is the code
> CREATE PROCEDURE [DBO].[TEST1] AS
> SET ANSI_NULLS ON
> SET ANSI_WARNINGS ON
> GO
> select sid from ......
> GO
> After this I attempted to alter the procdure still with no effect and
> finally I issued the sp_configure 'user options',
> '32' do set the default and still no luck does anyone have any other
> suggestions.
Well problem solved and lesson learned. The error I was receiving was
due to a bug in enterprize manager knowledge base 296769, create the
stored procedure using query analyiser and all is well.
Eric

Microsoft SQL-DMO (ODBC SQLState: 42000) Error 22022

Hi,
We have recently setup a new cluster server. At the moment
the resources have swapped over so that 1 is running on
node 2 and vice-versa.
However this appears to be causing a problem with the SQL
scheduled tasks. All tasks in the list have (Date and
Time are not available) under 'Next Run Date.' All the
tasks will try and run at their scheduled time however if
we try and manually execute tasks we get the error message
Microsoft SQL-DMO (ODBC SQLState: 42000) Error 22022:
SqlServerAgent Error: Job ... does not exist in the job
cache.
Has anyone seen this error before?
We do not have this problem on our other clustered servers.
Thanks in advance for your help.
Do you have SQL Server Agent starting with a domain account that is valid
on both nodes?
Are there any messages in the SQL Server or SQL Agent logs?
Are there any messages in the event logs?
Do the jobs refer to any files or other objects that only exist on one node?
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Microsoft SQL-DMO

I got an error as following while I am trying to restore a database:
Microsoft SQL-DMO (ODBC SQLState:42000)
Device activation error: The physical file name ... may be incorrect.
Please help how to solve this problem. Thanks.Allen,
Check your spelling of the file name you are trying to restore from.
They do not match.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Allen Iverson" wrote:
> I got an error as following while I am trying to restore a database:
> Microsoft SQL-DMO (ODBC SQLState:42000)
> Device activation error: The physical file name ... may be incorrect.
>
> Please help how to solve this problem. Thanks.
>|||Mark,
But I use the browser to open the file. So the spelling should
be OK.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
> Allen,
> Check your spelling of the file name you are trying to restore from. They
> do not match.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> "Allen Iverson" wrote:
>> I got an error as following while I am trying to restore a database:
>> Microsoft SQL-DMO (ODBC SQLState:42000)
>> Device activation error: The physical file name ... may be incorrect.
>>
>> Please help how to solve this problem. Thanks.|||Note that the restore is performed on the server. Are you sitting on the server when you use
explorer to get the file name?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
""Allen Iverson"" <no_spam@.bk.com> wrote in message news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
> Mark,
> But I use the browser to open the file. So the spelling should
> be OK.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
> > Allen,
> >
> > Check your spelling of the file name you are trying to restore from. They
> > do not match.
> >
> > --
> > Mark Allison, SQL Server MVP
> > http://www.markallison.co.uk
> >
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602m.html
> >
> >
> > "Allen Iverson" wrote:
> >> I got an error as following while I am trying to restore a database:
> >>
> >> Microsoft SQL-DMO (ODBC SQLState:42000)
> >>
> >> Device activation error: The physical file name ... may be incorrect.
> >>
> >>
> >> Please help how to solve this problem. Thanks.
>|||No, I am working on a client PC. But I did this before and no problem.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:erRDI7SpEHA.4004@.TK2MSFTNGP10.phx.gbl...
> Note that the restore is performed on the server. Are you sitting on the
> server when you use
> explorer to get the file name?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> ""Allen Iverson"" <no_spam@.bk.com> wrote in message
> news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
>> Mark,
>> But I use the browser to open the file. So the spelling
>> should
>> be OK.
>> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
>> news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
>> > Allen,
>> >
>> > Check your spelling of the file name you are trying to restore from.
>> > They
>> > do not match.
>> >
>> > --
>> > Mark Allison, SQL Server MVP
>> > http://www.markallison.co.uk
>> >
>> > Looking for a SQL Server replication book?
>> > http://www.nwsu.com/0974973602m.html
>> >
>> >
>> > "Allen Iverson" wrote:
>> >> I got an error as following while I am trying to restore a database:
>> >>
>> >> Microsoft SQL-DMO (ODBC SQLState:42000)
>> >>
>> >> Device activation error: The physical file name ... may be incorrect.
>> >>
>> >>
>> >> Please help how to solve this problem. Thanks.
>>
>|||The filename specified is seen from SQL Server's perspective. If the file isn't on the SQL Server
machine you have to specify an UNC path for the file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
""Allen Iverson"" <no_spam@.bk.com> wrote in message news:OceVUrbqEHA.2764@.TK2MSFTNGP11.phx.gbl...
> No, I am working on a client PC. But I did this before and no problem.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:erRDI7SpEHA.4004@.TK2MSFTNGP10.phx.gbl...
>> Note that the restore is performed on the server. Are you sitting on the server when you use
>> explorer to get the file name?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> ""Allen Iverson"" <no_spam@.bk.com> wrote in message news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
>> Mark,
>> But I use the browser to open the file. So the spelling should
>> be OK.
>> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
>> news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
>> > Allen,
>> >
>> > Check your spelling of the file name you are trying to restore from. They
>> > do not match.
>> >
>> > --
>> > Mark Allison, SQL Server MVP
>> > http://www.markallison.co.uk
>> >
>> > Looking for a SQL Server replication book?
>> > http://www.nwsu.com/0974973602m.html
>> >
>> >
>> > "Allen Iverson" wrote:
>> >> I got an error as following while I am trying to restore a database:
>> >>
>> >> Microsoft SQL-DMO (ODBC SQLState:42000)
>> >>
>> >> Device activation error: The physical file name ... may be incorrect.
>> >>
>> >>
>> >> Please help how to solve this problem. Thanks.
>>
>>
>

Microsoft SQL-DMO

I got an error as following while I am trying to restore a database:
Microsoft SQL-DMO (ODBC SQLState:42000)
Device activation error: The physical file name ... may be incorrect.
Please help how to solve this problem. Thanks.
Allen,
Check your spelling of the file name you are trying to restore from.
They do not match.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Allen Iverson" wrote:
> I got an error as following while I am trying to restore a database:
> Microsoft SQL-DMO (ODBC SQLState:42000)
> Device activation error: The physical file name ... may be incorrect.
>
> Please help how to solve this problem. Thanks.
>
|||Mark,
But I use the browser to open the file. So the spelling should
be OK.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Allen,
> Check your spelling of the file name you are trying to restore from. They
> do not match.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> "Allen Iverson" wrote:
|||Note that the restore is performed on the server. Are you sitting on the server when you use
explorer to get the file name?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
""Allen Iverson"" <no_spam@.bk.com> wrote in message news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
> Mark,
> But I use the browser to open the file. So the spelling should
> be OK.
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:%23VqEGHKpEHA.1308@.TK2MSFTNGP14.phx.gbl...
>
|||No, I am working on a client PC. But I did this before and no problem.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:erRDI7SpEHA.4004@.TK2MSFTNGP10.phx.gbl...
> Note that the restore is performed on the server. Are you sitting on the
> server when you use
> explorer to get the file name?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> ""Allen Iverson"" <no_spam@.bk.com> wrote in message
> news:ejiY39OpEHA.3324@.TK2MSFTNGP15.phx.gbl...
>
|||The filename specified is seen from SQL Server's perspective. If the file isn't on the SQL Server
machine you have to specify an UNC path for the file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
""Allen Iverson"" <no_spam@.bk.com> wrote in message news:OceVUrbqEHA.2764@.TK2MSFTNGP11.phx.gbl...
> No, I am working on a client PC. But I did this before and no problem.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:erRDI7SpEHA.4004@.TK2MSFTNGP10.phx.gbl...
>

Microsoft SQL Web Data Administrator

I have installed this and I cannot access my MSDE Instance. Any ideas?
The instance of my DB is running.
My Server Manager Says that it is running, Services says that it is running,
but I cannot get to the SQLServer (On my own pc) with the Web Data
Administrator or TOAD for SQL Server.
|||It is quite possible that it is running on a non-standard port not 1433.
Open up a console window and type following
PROMPT> telnet localhost 1433
if you see a blank screen that means the server is listening. If you get
an error that means that it is listening on a different port
Joe Tobey wrote:
> I have installed this and I cannot access my MSDE Instance. Any ideas?
> The instance of my DB is running.
|||It is listen in on a different PORT...how do I change that?
"Dennis Black" wrote:

> It is quite possible that it is running on a non-standard port not 1433.
> Open up a console window and type following
> PROMPT> telnet localhost 1433
> if you see a blank screen that means the server is listening. If you get
> an error that means that it is listening on a different port
>
> Joe Tobey wrote:
>
>
|||To determine the port MSDE is using, run the SQL Server Network Utility
on the machine hosting the MSDE instance. The SQL Server Network
Utility can be found at \Program Files\Microsoft SQL
Server\80\Tools\Binn\svrnetcn.exe.
On the general tab, select the your MSDE instance. Select TCP/IP and
press the Properties button and look at the port
Dennis
Joe Tobey wrote:[vbcol=seagreen]
> It is listen in on a different PORT...how do I change that?
> "Dennis Black" wrote:
>

Microsoft SQL Transaction Log

Can any one recommend a good Transaction Log viewer / analyzer for
Microsoft SQL?Check out www.lumigent.com.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<matthew.mccarty@.foxtg.com> wrote in message
news:1144852551.532336.105040@.j33g2000cwa.googlegroups.com...
Can any one recommend a good Transaction Log viewer / analyzer for
Microsoft SQL?|||Thanks for the link.
Can LogExplorer view logs that where created before the software is
installed on the server?
Thanks,
Matt|||I believe so. You may want to contact them directly.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Traxs" <matthew.mccarty@.foxtg.com> wrote in message
news:1144854286.523969.275510@.v46g2000cwv.googlegroups.com...
Thanks for the link.
Can LogExplorer view logs that where created before the software is
installed on the server?
Thanks,
Matt|||<matthew.mccarty@.foxtg.com> wrote in message
news:1144852551.532336.105040@.j33g2000cwa.googlegroups.com...
> Can any one recommend a good Transaction Log viewer / analyzer for
> Microsoft SQL?
>
Here is a FREE one:
SELECT * FROM ::fn_dblog(NULL, NULL)
The params are Start LSN and End LSN respectivly.

Microsoft SQL Transaction Log

Can any one recommend a good Transaction Log viewer / analyzer for
Microsoft SQL?Check out www.lumigent.com.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<matthew.mccarty@.foxtg.com> wrote in message
news:1144852551.532336.105040@.j33g2000cwa.googlegroups.com...
Can any one recommend a good Transaction Log viewer / analyzer for
Microsoft SQL?|||Thanks for the link.
Can LogExplorer view logs that where created before the software is
installed on the server?
Thanks,
Matt|||I believe so. You may want to contact them directly.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Traxs" <matthew.mccarty@.foxtg.com> wrote in message
news:1144854286.523969.275510@.v46g2000cwv.googlegroups.com...
Thanks for the link.
Can LogExplorer view logs that where created before the software is
installed on the server?
Thanks,
Matt|||<matthew.mccarty@.foxtg.com> wrote in message
news:1144852551.532336.105040@.j33g2000cwa.googlegroups.com...
> Can any one recommend a good Transaction Log viewer / analyzer for
> Microsoft SQL?
>
Here is a FREE one:
SELECT * FROM ::fn_dblog(NULL, NULL)
The params are Start LSN and End LSN respectivly.

Microsoft SQL Sever management Studio: Failed to open connection dialog

Does anyone encount the following problem before? When I tried to connect to Microsoft SQL server 2005 with MS SQL Server Management Studio, I received: "Failed to open connection dialog" message with additional information is "Package 'Mircrosoft SQL Server Object Explorer' failed to load.

This's just happened recently. Although I am receiving that message, I still able access into database with different types of connection.

Can someone shred some light?

Thanks

Tommy.

Have you attempted to connect the server using another client's machine.|||

This looks like some of your .NET components have corrupted. Reinstalling the same should help.

Thanks,
Kuntal

|||

The most likely cause of this is if a file has been deleted or corrupted. Does repairing the SQL Server management tools fix the problem?

Repairing SQL Server is a command-line operation. You can repair by inserting the installation media into the disk drive and typing the following:

start /wait <CD or DVD Drive>\setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS

You can find more information on installing SQL Server from the command line here: http://msdn2.microsoft.com/en-us/library/ms144259.aspx

|||

Good morning ( or afternoon for me )

Goo and helpful answer whether you have the cd disk but if you have downloaded from Microsoft (for example Express Edition or School version ), i think i must contact Microsoft to have the agreement to downloa and validate again

Have a nice day

Microsoft SQL Sever management Studio: Failed to open connection dialog

Does anyone encount the following problem before? When I tried to connect to Microsoft SQL server 2005 with MS SQL Server Management Studio, I received: "Failed to open connection dialog" message with additional information is "Package 'Mircrosoft SQL Server Object Explorer' failed to load.

This's just happened recently. Although I am receiving that message, I still able access into database with different types of connection.

Can someone shred some light?

Thanks

Tommy.

Have you attempted to connect the server using another client's machine.|||

This looks like some of your .NET components have corrupted. Reinstalling the same should help.

Thanks,
Kuntal

|||

The most likely cause of this is if a file has been deleted or corrupted. Does repairing the SQL Server management tools fix the problem?

Repairing SQL Server is a command-line operation. You can repair by inserting the installation media into the disk drive and typing the following:

start /wait <CD or DVD Drive>\setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS

You can find more information on installing SQL Server from the command line here: http://msdn2.microsoft.com/en-us/library/ms144259.aspx

|||

Good morning ( or afternoon for me )

Goo and helpful answer whether you have the cd disk but if you have downloaded from Microsoft (for example Express Edition or School version ), i think i must contact Microsoft to have the agreement to downloa and validate again

Have a nice day

Microsoft SQL Sever 2005 Express <> Mixed authentication.

Hello dear all,
I'm not sure if I'm posting to the right newsgroup,
if not please direct me to the right one.
I've installed "Microsoft SQL Server 2005 Express",
and now I can log on only with windows authentication,
I tried to follow : http://support.microsoft.com/kb/269587/en-us
instructions, which says it's indeed for all versions of SQL Server,
but first I don't have Enterprise Manager, I have "SQL Server Configuration
Manager",
and in there I don't find "Server" group as it says to expand it.
so basically I cannot set authentication to mixed.
I need to log on with sql authentication not with windows one.
Help much appreciated.
Thanks
Hi George,
http://support.microsoft.com/default...;EN-US;q285097
INF: How to Change the Default Login Authentication Mode to SQL While
Installing SQL Server 2000 Desktop Engine by Using Windows Installer
<snip>
Another way to change the security mode after installation is to stop
SQL Server and set the appropriate registry key for your installation:
Default instance:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
Named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\LoginMode
to 2 for mixed-mode or 1 for integrated. (Integrated is the default
setup for the SQL Server 2000 Data Engine.)
</snip>
Restart the service after this procedure.
HTH, jens Suessmeyer.
|||Hello Jens,
thank you very much for answering.
I don't have the registry keys that you mentioned.
1) HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
I don't have this.
in my registry it goes till:
HKLM\Software\Microsoft\MSSqlserver\ "here I've got only one entry" \Client
2)HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\LoginMode
I don't have this neither.
in my registry it goes till:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Names\ "and here I have just one entry" \SQL
Regards.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1139301968.599548.102040@.g43g2000cwa.googlegr oups.com...
> Hi George,
> http://support.microsoft.com/default...;EN-US;q285097
> INF: How to Change the Default Login Authentication Mode to SQL While
> Installing SQL Server 2000 Desktop Engine by Using Windows Installer
> <snip>
> Another way to change the security mode after installation is to stop
> SQL Server and set the appropriate registry key for your installation:
>
> Default instance:
> HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
>
> Named instance:
> HKLM\Software\Microsoft\Microsoft SQL Server\Instance
> Name\MSSQLServer\LoginMode
>
> to 2 for mixed-mode or 1 for integrated. (Integrated is the default
> setup for the SQL Server 2000 Data Engine.)
> </snip>
> Restart the service after this procedure.
>
> HTH, jens Suessmeyer.
>
|||Are you sure that you installe a instance of SQL Server Express on your
computer ?
|||Have you checked for LoginMode under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.2\MSSQLServer
Note: the MSSQL.2 can be any number based on logic that normally starts
at 1 as in
MSSQL.1
Tim S
|||Hello there,
thanks a lot,
I just found that key.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\MSSQLServer
I have it here.
I'll go try right now... and tell then if it worked...
"Tim" <stahta01@.juno.com> wrote in message
news:1139346215.000850.4360@.o13g2000cwo.googlegrou ps.com...
> Have you checked for LoginMode under
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> Server\MSSQL.2\MSSQLServer
> Note: the MSSQL.2 can be any number based on logic that normally starts
> at 1 as in
> MSSQL.1
> Tim S
>
|||worked as a charm ))
thank you very much Jens.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1139329297.715620.178700@.g44g2000cwa.googlegr oups.com...
> Are you sure that you installe a instance of SQL Server Express on your
> computer ?
>

Microsoft SQL Sever 2005 Express <> Mixed authentication.

Hello dear all,
I'm not sure if I'm posting to the right newsgroup,
if not please direct me to the right one.
I've installed "Microsoft SQL Server 2005 Express",
and now I can log on only with windows authentication,
I tried to follow : http://support.microsoft.com/kb/269587/en-us
instructions, which says it's indeed for all versions of SQL Server,
but first I don't have Enterprise Manager, I have "SQL Server Configuration
Manager",
and in there I don't find "Server" group as it says to expand it.
so basically I cannot set authentication to mixed.
I need to log on with sql authentication not with windows one.
Help much appreciated.
ThanksHi George,
---
http://support.microsoft.com/defaul...b;EN-US;q285097
---
INF: How to Change the Default Login Authentication Mode to SQL While
Installing SQL Server 2000 Desktop Engine by Using Windows Installer
---
<snip>
Another way to change the security mode after installation is to stop
SQL Server and set the appropriate registry key for your installation:
Default instance:
HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMode
Named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\LoginMode
to 2 for mixed-mode or 1 for integrated. (Integrated is the default
setup for the SQL Server 2000 Data Engine.)
</snip>
Restart the service after this procedure.
HTH, jens Suessmeyer.|||Hello Jens,
thank you very much for answering.
I don't have the registry keys that you mentioned.
1) HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMode
I don't have this.
in my registry it goes till:
HKLM\Software\Microsoft\MSSqlserver\ "here I've got only one entry" \Client
2)HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\LoginMode
I don't have this neither.
in my registry it goes till:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Names\ "and here I have just one entry" \SQL
Regards.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1139301968.599548.102040@.g43g2000cwa.googlegroups.com...
> Hi George,
> ---
> http://support.microsoft.com/defaul...b;EN-US;q285097
> ---
> INF: How to Change the Default Login Authentication Mode to SQL While
> Installing SQL Server 2000 Desktop Engine by Using Windows Installer
> ---
> <snip>
> Another way to change the security mode after installation is to stop
> SQL Server and set the appropriate registry key for your installation:
>
> Default instance:
> HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMode
>
> Named instance:
> HKLM\Software\Microsoft\Microsoft SQL Server\Instance
> Name\MSSQLServer\LoginMode
>
> to 2 for mixed-mode or 1 for integrated. (Integrated is the default
> setup for the SQL Server 2000 Data Engine.)
> </snip>
> Restart the service after this procedure.
>
> HTH, jens Suessmeyer.
>|||Are you sure that you installe a instance of SQL Server Express on your
computer ?|||Have you checked for LoginMode under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQL.2\MSSQLServer
Note: the MSSQL.2 can be any number based on logic that normally starts
at 1 as in
MSSQL.1
Tim S|||Hello there,
thanks a lot,
I just found that key.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQL.1\MSSQLServer
I have it here.
I'll go try right now... and tell then if it worked...
"Tim" <stahta01@.juno.com> wrote in message
news:1139346215.000850.4360@.o13g2000cwo.googlegroups.com...
> Have you checked for LoginMode under
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
> Server\MSSQL.2\MSSQLServer
> Note: the MSSQL.2 can be any number based on logic that normally starts
> at 1 as in
> MSSQL.1
> Tim S
>|||worked as a charm ))
thank you very much Jens.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1139329297.715620.178700@.g44g2000cwa.googlegroups.com...
> Are you sure that you installe a instance of SQL Server Express on your
> computer ?
>

Microsoft SQL Server, Error: 87 17march

Source computer: SQL server 2005 SP1
Remote computer : SQLEXPRESS
When I try to register/connect with remote server (named instance) using sql
server management studio I am getting following error:
TITLE: New Server Registration
--
Testing the registered server failed. Verify the server name, login
credentials, and database, and then click Test again.
--
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting 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: SQL Network Interfaces, error: 25 - Connection string is not
valid) (Microsoft SQL Server, Error: 87)
Thanks
Ontario, canadaSource computer: SQL server 2005 SP1 (Microsoft windows nt 5.1)
Remote computer : Microsoft SQL server express edition (Microsoft windows
nt 5.1)
-
ontario, canada
"db" wrote:
> Source computer: SQL server 2005 SP1
> Remote computer : SQLEXPRESS
>
> When I try to register/connect with remote server (named instance) using sql
> server management studio I am getting following error:
> TITLE: New Server Registration
> --
> Testing the registered server failed. Verify the server name, login
> credentials, and database, and then click Test again.
> --
> ADDITIONAL INFORMATION:
> An error has occurred while establishing a connection to the server. When
> connecting 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: SQL Network Interfaces, error: 25 - Connection string is not
> valid) (Microsoft SQL Server, Error: 87)
>
> Thanks
> Ontario, canada

Microsoft SQL Server, Error: 87 17march

Source computer: SQL server 2005 SP1
Remote computer : SQLEXPRESS
When I try to register/connect with remote server (named instance) using sql
server management studio I am getting following error:
TITLE: New Server Registration
Testing the registered server failed. Verify the server name, login
credentials, and database, and then click Test again.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting 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: SQL Network Interfaces, error: 25 - Connection string is not
valid) (Microsoft SQL Server, Error: 87)
Thanks
Ontario, canada
Source computer: SQL server 2005 SP1 (Microsoft windows nt 5.1)
Remote computer : Microsoft SQL server express edition (Microsoft windows
nt 5.1)
-
ontario, canada
"db" wrote:

> Source computer: SQL server 2005 SP1
> Remote computer : SQLEXPRESS
>
> When I try to register/connect with remote server (named instance) using sql
> server management studio I am getting following error:
> TITLE: New Server Registration
> --
> Testing the registered server failed. Verify the server name, login
> credentials, and database, and then click Test again.
> --
> ADDITIONAL INFORMATION:
> An error has occurred while establishing a connection to the server. When
> connecting 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: SQL Network Interfaces, error: 25 - Connection string is not
> valid) (Microsoft SQL Server, Error: 87)
>
> Thanks
> Ontario, canada

Microsoft SQL Server, Error: 53

hi, i am trying to acces my database but i get this error. I allowed remote
connections in sql server 2005 but i still get the error.
TITLE: Connect to Server
Cannot connect to MSSQLSERVER.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting 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) (Microsoft SQL Server, Error: 53)
Hoping for some help , kind regards xenta.
How is the client configured? Check with cliconfg.exe.
What app are you using? If not a tool like QA, SSMS etc, then what does the connection string look
like?
How is the server configured? Check with SQL Server Configuration Manager. Does it listen to Named
Pipes, for instance.
The error states that the client tries to connect using Named Pipes.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"zentax" <millionsmillions@.hotmail.com> wrote in message
news:eYGOxgcdHHA.2088@.TK2MSFTNGP05.phx.gbl...
> hi, i am trying to acces my database but i get this error. I allowed remote connections in sql
> server 2005 but i still get the error.
> TITLE: Connect to Server
> --
> Cannot connect to MSSQLSERVER.
> --
> ADDITIONAL INFORMATION:
> An error has occurred while establishing a connection to the server. When connecting 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) (Microsoft SQL Server, Error: 53)
>
> Hoping for some help , kind regards xenta.
>
>

Microsoft SQL Server, Error: 53

hi, i am trying to acces my database but i get this error. I allowed remote
connections in sql server 2005 but i still get the error.
TITLE: Connect to Server
--
Cannot connect to MSSQLSERVER.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting 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) (Microsoft SQL Server, Error: 53)
Hoping for some help , kind regards xenta.How is the client configured? Check with cliconfg.exe.
What app are you using? If not a tool like QA, SSMS etc, then what does the
connection string look
like?
How is the server configured? Check with SQL Server Configuration Manager. D
oes it listen to Named
Pipes, for instance.
The error states that the client tries to connect using Named Pipes.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"zentax" <millionsmillions@.hotmail.com> wrote in message
news:eYGOxgcdHHA.2088@.TK2MSFTNGP05.phx.gbl...
> hi, i am trying to acces my database but i get this error. I allowed remot
e connections in sql
> server 2005 but i still get the error.
> TITLE: Connect to Server
> --
> Cannot connect to MSSQLSERVER.
> --
> ADDITIONAL INFORMATION:
> An error has occurred while establishing a connection to the server. When
connecting 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) (Microsoft SQL Server, Error: 53)
>
> Hoping for some help , kind regards xenta.
>
>

Microsoft SQL Server, Error: 53

hi, i am trying to acces my database but i get this error. I allowed remote
connections in sql server 2005 but i still get the error.
TITLE: Connect to Server
--
Cannot connect to MSSQLSERVER.
--
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting 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) (Microsoft SQL Server, Error: 53)
Hoping for some help , kind regards xenta.How is the client configured? Check with cliconfg.exe.
What app are you using? If not a tool like QA, SSMS etc, then what does the connection string look
like?
How is the server configured? Check with SQL Server Configuration Manager. Does it listen to Named
Pipes, for instance.
The error states that the client tries to connect using Named Pipes.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"zentax" <millionsmillions@.hotmail.com> wrote in message
news:eYGOxgcdHHA.2088@.TK2MSFTNGP05.phx.gbl...
> hi, i am trying to acces my database but i get this error. I allowed remote connections in sql
> server 2005 but i still get the error.
> TITLE: Connect to Server
> --
> Cannot connect to MSSQLSERVER.
> --
> ADDITIONAL INFORMATION:
> An error has occurred while establishing a connection to the server. When connecting 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) (Microsoft SQL Server, Error: 53)
>
> Hoping for some help , kind regards xenta.
>
>