Migrating Enterprise Manager Server List

Hi All,
I have just installed EM for SQL Server 2000 and so have no registered servers in the console list. We have about 50 servers which we support and so I would rather import my colleagues list rather than registering them all manually. Is there ay way to do this ?
Many thanks
AndyUSE THIS AT YOUR OWN RISK. Works for me !! I accept no responsibility for anything :)

Well, this is a solution I would not attribute to myself , coz i did never invent it myself.

Register all your servers in one Enterprise Manager.

Then go to these keys :
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\SuperSocketNetLib\LastConnect]

[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X]


and export them.

Share the .reg files with your colleagues. Enjoy|||Enigma,
Thanks a lot... this worked a treat.
Cheers
Andysql

Migrating a database

We have a database running under SQL Server 7 on a Win NT server. We
have recently added Win2K servers, created a new domain and installed
SQL Server 7 on one of the servers. I would like to be able to log into
either domain from a workstation, use Enterprise Manager to access
either database and use the migration tools to copy the database from
the NT server to the 2K server.
We have created a trust relationship that allows me to log into either
domain, but when I try to use Enterprise Manager to create a
registration to the database on the other domain, or try to use the
migration tool to copy the database, I get an error saying that my user
account cannot log into the other system. ( I have the same user name
and password on both domains and domain admin privileges).
Can this be done directly? How?
Do I need "linked servers"? -- It doesn't like my account to create this
either.
Do I need a "remote server"?
Reading the documentation creates more questions than answers. I would
appreciate someone pointing me in the right direction. ThanksWhat is the exact error you are seeing and which domain are you logging
into, the new one or the other one.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||When I'm logged into the NT domain and trying to register SQL Server on the 2K
server, I get "login failed for user 'patenaude'".
When I'm logged into the 2K domain and trying to register SQL server on the NT
server, I get " loged failed for user 'null'. Not associated with a trusted
SQL Server connection."
I get similar messages trying to set up a linked server.
"Rand Boyd [MS]" wrote:
> What is the exact error you are seeing and which domain are you logging
> into, the new one or the other one.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.|||When you are logged into the Windows NT domain are you trying to register
the SQL Server using NT or SQL authentication. The error indicates SQL
authentication. If so does the 'patenaude' SQL login exist? Is the password
correct?
When you are logging into the Win 2K domain, the error indicates that you
cannot be validated on the domain controller. That is where the null is
coming from. Check the security log of the domain controller for this
domain for errors related to this account. Also if you are logged on to the
workstation using a local account you will see this error.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I changed the system on the 2K server to use NT authentication, so now I get
the same error message about my user account not being valid. (The user id is
good, the password is good.) My workstation is a member of the NT domain and
the trust relationship is set up to the point where I can log into either
domain. The user name is the same on both domains. I have tried registering
across the domain from both directions, using the default log-in with NT
authentication, using the specific login with my user name and using the
specific log-in with each of the domains added ( NTdomain\user & 2Kdomain\user)
I get the same results each time. I looked in the event logs on the servers and
there is no mention of the attempt in any of the logs.
"Rand Boyd [MS]" wrote:
> When you are logged into the Windows NT domain are you trying to register
> the SQL Server using NT or SQL authentication. The error indicates SQL
> authentication. If so does the 'patenaude' SQL login exist? Is the password
> correct?
> When you are logging into the Win 2K domain, the error indicates that you
> cannot be validated on the domain controller. That is where the null is
> coming from. Check the security log of the domain controller for this
> domain for errors related to this account. Also if you are logged on to the
> workstation using a local account you will see this error.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.

migrate SQL 2000 system users

I have installed a new SQL 2005 server and successfully moved a db from one to the other. The users from that db were also imported, but the system security was not. Users cannot access the SQL system to even attempt to login to the db. What am I missing to import/transfer/migrate the system logins from SQL2000 to SQL2005?

Thanks

David

Moving to the setup and upgrade forum.

Donald

|||

Take a look at http://support.microsoft.com/kb/918992/

Thanks,

Peter

Migrate existing standalone to cluster

While away on vacation my company had some software installed that required a
new instance of SQL Server 2K to be created on our existing active/passive
cluster.
Because the techs doing the install did not know the password for our domain
cluster user account they created the standalone instance on the db server.
What I need to know is how do I go about migrating it to a clustered instance
instead of a standalone so as to take advantage of the failover capabilities?
i.e. I already have a clustered server with one clustered instance. They
installed a standalone instance alongside and now I need to migrate the new
instance to another named clustered instance.
Is it possible to go with the existing clustered instance and simply move
the DB's to the cluster? What's driving the need for two instances?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Cary" <Cary@.discussions.microsoft.com> wrote in message
news:F9743B37-FC4D-4909-A4CA-608078BB5A3E@.microsoft.com...
While away on vacation my company had some software installed that required
a
new instance of SQL Server 2K to be created on our existing active/passive
cluster.
Because the techs doing the install did not know the password for our domain
cluster user account they created the standalone instance on the db server.
What I need to know is how do I go about migrating it to a clustered
instance
instead of a standalone so as to take advantage of the failover
capabilities?
i.e. I already have a clustered server with one clustered instance. They
installed a standalone instance alongside and now I need to migrate the new
instance to another named clustered instance.
|||Oh you'll love this...
The software we purchased for our new document management system *cough*
Documentum *cough*, is designed so as to require a case-sensitive database.
I know...D-U-M Dum...And because all of our other databases are NOT
case-sensitive (and there's no way in h*ll I would change that) we had to
create a new instance that was.
"Tom Moreau" wrote:

> Is it possible to go with the existing clustered instance and simply move
> the DB's to the cluster? What's driving the need for two instances?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "Cary" <Cary@.discussions.microsoft.com> wrote in message
> news:F9743B37-FC4D-4909-A4CA-608078BB5A3E@.microsoft.com...
> While away on vacation my company had some software installed that required
> a
> new instance of SQL Server 2K to be created on our existing active/passive
> cluster.
> Because the techs doing the install did not know the password for our domain
> cluster user account they created the standalone instance on the db server.
> What I need to know is how do I go about migrating it to a clustered
> instance
> instead of a standalone so as to take advantage of the failover
> capabilities?
> i.e. I already have a clustered server with one clustered instance. They
> installed a standalone instance alongside and now I need to migrate the new
> instance to another named clustered instance.
>
|||That's not justification enough. You can create a case-sensitive database
within an instance that is not case sensitive.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Cary" <Cary@.discussions.microsoft.com> wrote in message
news:A8F1525E-3D96-4842-AFBD-87160EC34CB8@.microsoft.com...
Oh you'll love this...
The software we purchased for our new document management system *cough*
Documentum *cough*, is designed so as to require a case-sensitive database.
I know...D-U-M Dum...And because all of our other databases are NOT
case-sensitive (and there's no way in h*ll I would change that) we had to
create a new instance that was.
"Tom Moreau" wrote:

> Is it possible to go with the existing clustered instance and simply move
> the DB's to the cluster? What's driving the need for two instances?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "Cary" <Cary@.discussions.microsoft.com> wrote in message
> news:F9743B37-FC4D-4909-A4CA-608078BB5A3E@.microsoft.com...
> While away on vacation my company had some software installed that
> required
> a
> new instance of SQL Server 2K to be created on our existing active/passive
> cluster.
> Because the techs doing the install did not know the password for our
> domain
> cluster user account they created the standalone instance on the db
> server.
> What I need to know is how do I go about migrating it to a clustered
> instance
> instead of a standalone so as to take advantage of the failover
> capabilities?
> i.e. I already have a clustered server with one clustered instance. They
> installed a standalone instance alongside and now I need to migrate the
> new
> instance to another named clustered instance.
>
|||Not that it will matter much anyway, since it is already installed, but how
do you go about making a case-sensitive db inside of an insensitive instance?
And I still need to know how to change the standalone to a clustered...
"Tom Moreau" wrote:

> That's not justification enough. You can create a case-sensitive database
> within an instance that is not case sensitive.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "Cary" <Cary@.discussions.microsoft.com> wrote in message
> news:A8F1525E-3D96-4842-AFBD-87160EC34CB8@.microsoft.com...
> Oh you'll love this...
> The software we purchased for our new document management system *cough*
> Documentum *cough*, is designed so as to require a case-sensitive database.
> I know...D-U-M Dum...And because all of our other databases are NOT
> case-sensitive (and there's no way in h*ll I would change that) we had to
> create a new instance that was.
> "Tom Moreau" wrote:
>
>
|||To create a database with a case-sensitive collation, just use the COLLATE
option:
create database MyDB
collate Latin1_General_CS_AI
As for the other bit, you'll have to create the new virtual server (and
named instance) in the same manner as you created the other virtual server
and instance. However, you can specify the collation for the new instance
at that time. Once that's done, then backup and restore the DB's from the
standalone to the new instance. Finally, remove the standalone.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Cary" <Cary@.discussions.microsoft.com> wrote in message
news:FBFC5A77-4A41-4B6E-B076-370E9111321B@.microsoft.com...
Not that it will matter much anyway, since it is already installed, but how
do you go about making a case-sensitive db inside of an insensitive
instance?
And I still need to know how to change the standalone to a clustered...
"Tom Moreau" wrote:

> That's not justification enough. You can create a case-sensitive database
> within an instance that is not case sensitive.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "Cary" <Cary@.discussions.microsoft.com> wrote in message
> news:A8F1525E-3D96-4842-AFBD-87160EC34CB8@.microsoft.com...
> Oh you'll love this...
> The software we purchased for our new document management system *cough*
> Documentum *cough*, is designed so as to require a case-sensitive
> database.
> I know...D-U-M Dum...And because all of our other databases are NOT
> case-sensitive (and there's no way in h*ll I would change that) we had to
> create a new instance that was.
> "Tom Moreau" wrote:
>
>
|||Creating a database in an instance with a collation that is differnt than
the default server collation, as Tom suggested, is certainly one approach
you can explore. If everything is under your control, you can make this
work. A vendor package like Ducumentum, however, may crap out becasue of the
likely collation conflict with the tempdb database. So test it out!
Linchi
"Cary" <Cary@.discussions.microsoft.com> wrote in message
news:FBFC5A77-4A41-4B6E-B076-370E9111321B@.microsoft.com...[vbcol=seagreen]
> Not that it will matter much anyway, since it is already installed, but
> how
> do you go about making a case-sensitive db inside of an insensitive
> instance?
> And I still need to know how to change the standalone to a clustered...
>
> "Tom Moreau" wrote:
|||Question regarding what Linchi wrote about the temp DB being an issue. We
are currently in the same situation with a mulitnode cluster that will house
a peoplesoft instance (different collation than the other instances) but have
concerns on how failover will happen with this different collation instance
vs the collation instances that are indentical. Will failover happen just as
if all the collations were the same or do we have to take special precautions?
"Linchi Shea" wrote:

> Creating a database in an instance with a collation that is differnt than
> the default server collation, as Tom suggested, is certainly one approach
> you can explore. If everything is under your control, you can make this
> work. A vendor package like Ducumentum, however, may crap out becasue of the
> likely collation conflict with the tempdb database. So test it out!
> Linchi
> "Cary" <Cary@.discussions.microsoft.com> wrote in message
> news:FBFC5A77-4A41-4B6E-B076-370E9111321B@.microsoft.com...
>
>
|||Multiple collations are no different on a cluster than on a stand-alone box.
Failover will work exactly the same regardless of the system or anyuser
database collation. Collations have been separated from the system code
page since SQL 7.0
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Todd" <Todd@.discussions.microsoft.com> wrote in message
news:32F54FD8-2882-4125-8202-D6CE442C83E5@.microsoft.com...[vbcol=seagreen]
> Question regarding what Linchi wrote about the temp DB being an issue. We
> are currently in the same situation with a mulitnode cluster that will
> house
> a peoplesoft instance (different collation than the other instances) but
> have
> concerns on how failover will happen with this different collation
> instance
> vs the collation instances that are indentical. Will failover happen just
> as
> if all the collations were the same or do we have to take special
> precautions?
> "Linchi Shea" wrote:

Migrate database from MS Access to SQL Server 2000

Hi All,
I had installed Internet Information Sevices (IIS) on
Windows 2000 to simulate a web server. The ASP code to
open the Access database is:
Set db = Server.CreateObject("ADODB.Connection")
db.open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="
&server.MapPath("../data/test.mdb")&";"
The code works fine on IIS and Access database. Then I
installed the SQL Server 2000 and changed the ASP code to:
Set db = Server.CreateObject("ADODB.Connection")
db.open "DRIVER={SQL
Server};SERVER=myPC;UID=sa;PWD=myPasswd;DATABASE=test"
dbsql="Y"
Where "myPC" is the computer name, "myPasswd" is the
password for user "sa". But the ASP code did not work.
Anything wrong?
Thanks in advance.> But the ASP code did not work.
You're going to have to be more specific.|||what error do u get'
--
Shaju Thomas
"Nancy" <nlan2000@.hotmail.com> wrote in message
news:063401c39b88$7ea843c0$a301280a@.phx.gbl...
> Hi All,
> I had installed Internet Information Sevices (IIS) on
> Windows 2000 to simulate a web server. The ASP code to
> open the Access database is:
> Set db = Server.CreateObject("ADODB.Connection")
> db.open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="
> &server.MapPath("../data/test.mdb")&";"
> The code works fine on IIS and Access database. Then I
> installed the SQL Server 2000 and changed the ASP code to:
> Set db = Server.CreateObject("ADODB.Connection")
> db.open "DRIVER={SQL
> Server};SERVER=myPC;UID=sa;PWD=myPasswd;DATABASE=test"
> dbsql="Y"
> Where "myPC" is the computer name, "myPasswd" is the
> password for user "sa". But the ASP code did not work.
> Anything wrong?
> Thanks in advance.
>|||Hi all,
Thanks for your kindness help.
The error message says:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Error Type:
ADODB.Recordset (0x800A0E7D)
The connection cannot be used to perform this operation.
It is either closed or invalid in this context.
Which referred to the following code:
set rs=Server.CreateObject("ADODB.Recordset")
The reason is the database connection was not set up
successfully, where the cause was actually a typo in the
server name. It works now after I corrected it.
But thanks anyway!
Nancy
>--Original Message--
>Hi All,
>I had installed Internet Information Sevices (IIS) on
>Windows 2000 to simulate a web server. The ASP code to
>open the Access database is:
>Set db = Server.CreateObject("ADODB.Connection")
>db.open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="
>&server.MapPath("../data/test.mdb")&";"
>The code works fine on IIS and Access database. Then I
>installed the SQL Server 2000 and changed the ASP code to:
>Set db = Server.CreateObject("ADODB.Connection")
>db.open "DRIVER={SQL
>Server};SERVER=myPC;UID=sa;PWD=myPasswd;DATABASE=test"
>dbsql="Y"
>Where "myPC" is the computer name, "myPasswd" is the
>password for user "sa". But the ASP code did not work.
>Anything wrong?
>Thanks in advance.
>.
>|||did u open the connection
--
Shaju Thomas
"Nancy" <nlan2000@.hotmail.com> wrote in message
news:055a01c39d0b$9fc67390$a601280a@.phx.gbl...
> Hi all,
> Thanks for your kindness help.
> The error message says:
> HTTP 500.100 - Internal Server Error - ASP error
> Internet Information Services
> Error Type:
> ADODB.Recordset (0x800A0E7D)
> The connection cannot be used to perform this operation.
> It is either closed or invalid in this context.
> Which referred to the following code:
> set rs=Server.CreateObject("ADODB.Recordset")
> The reason is the database connection was not set up
> successfully, where the cause was actually a typo in the
> server name. It works now after I corrected it.
> But thanks anyway!
> Nancy
>
> >--Original Message--
> >Hi All,
> >
> >I had installed Internet Information Sevices (IIS) on
> >Windows 2000 to simulate a web server. The ASP code to
> >open the Access database is:
> >
> >Set db = Server.CreateObject("ADODB.Connection")
> >db.open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="
> >&server.MapPath("../data/test.mdb")&";"
> >
> >The code works fine on IIS and Access database. Then I
> >installed the SQL Server 2000 and changed the ASP code to:
> >
> >Set db = Server.CreateObject("ADODB.Connection")
> >db.open "DRIVER={SQL
> >Server};SERVER=myPC;UID=sa;PWD=myPasswd;DATABASE=test"
> >dbsql="Y"
> >
> >Where "myPC" is the computer name, "myPasswd" is the
> >password for user "sa". But the ASP code did not work.
> >
> >Anything wrong?
> >
> >Thanks in advance.
> >
> >.
> >

Microsoft.VC80.CRT.mui

I have SQL 2005, 64bit version installed with SP1. I am seeing the following
errors in the Windows event log:
Source: SideBySide Event ID: 59
Resolve Partial Assembly failed for Microsoft.VC80.CRT.mui. Reference error
message: Access is denied.
Source: SidebySide EventID: 59
Generate Activation Context failed for D:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\bin\msmdctr90.DLL. Reference error message: Access is
denied.
Source: PerfLib EventID: 1023
Windows cannot load extensible counter DLL MSSQLServerOLAPService, the first
DWORD in data section is the Windows error code.
Does anyone know what the problem is?
Thanks
--
LehrSJHello LehrSJ,
I understand that you found some SQL related events on a SQL 2005 SP1 64bit
server, and you'd like to know what this problem is.
Based on my experience, this issue could occur if the "Performance Logs and
Alerts" service runs as "Network Service", which is member of "Performance
Log Users" local user group, does not have enough permission to SQL setup
folder.
SQL Setup grants read/execute permissions to "Performance Log Users" local
user group for the DLL only. "Performance Log Users" doesn?t have any
permissions for the containing folder. Granting "List folder contents"
permission to "Performance Log Users" for the containing folder (SQL Server
binn directory) may fix this problem:
D:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\bin
D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin
If you have any update or the issue is not resolved, please feel free to
let's know. I look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks. That solved the problem.
--
LehrSJ
""privatenews"" wrote:
> Hello LehrSJ,
> I understand that you found some SQL related events on a SQL 2005 SP1 64bit
> server, and you'd like to know what this problem is.
> Based on my experience, this issue could occur if the "Performance Logs and
> Alerts" service runs as "Network Service", which is member of "Performance
> Log Users" local user group, does not have enough permission to SQL setup
> folder.
> SQL Setup grants read/execute permissions to "Performance Log Users" local
> user group for the DLL only. "Performance Log Users" doesnâ't have any
> permissions for the containing folder. Granting "List folder contents"
> permission to "Performance Log Users" for the containing folder (SQL Server
> binn directory) may fix this problem:
> D:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\bin
> D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin
> If you have any update or the issue is not resolved, please feel free to
> let's know. I look forward to your reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||I was having this problem as well on a 32 bit system and that fixed it.
Can you explain why that fixed it? I'm asking because I was also having
2 other problems that I think this fixed as well.
first one: There is a Java program that inserts updates and deletes
records in a very large table on the sql server. It spawns 12 processes
that each have a connection to the DB and every time this program ran,
2 of them would hang up and would not receive any errors. I looked and
they were no longer connected.
second one: The users of this server have pocket pcs that connect using
sql ce server with RDA. They use an app that we wrote to replicate
their data. Along with all the pushing and pulling of tables, there is
one stored procedure that the client runs on the server. Apparently
randomly this stored procedure stops working for about 30 minutes at a
time. What happens on the client is when it calls that sp, it just
hangs there maintaining it's connection until all the sudden the sp
start working again. During the 30 minutes nobody can run the sp.
Both of these problems did not exist before we got Error 59 or after it
was fixed.
Does anybody have any clue as to why this would fix these 2 problems or
has anybody experienced anything like this?
thanks,
cob

Microsoft.VC80.CRT.mui

I have SQL 2005, 64bit version installed with SP1. I am seeing the followin
g
errors in the Windows event log:
Source: SideBySide Event ID: 59
Resolve Partial Assembly failed for Microsoft.VC80.CRT.mui. Reference error
message: Access is denied.
Source: SidebySide EventID: 59
Generate Activation Context failed for D:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\bin\msmdctr90.DLL. Reference error message: Access is
denied.
Source: PerfLib EventID: 1023
Windows cannot load extensible counter DLL MSSQLServerOLAPService, the first
DWORD in data section is the Windows error code.
Does anyone know what the problem is?
Thanks
--
LehrSJHello LehrSJ,
I understand that you found some SQL related events on a SQL 2005 SP1 64bit
server, and you'd like to know what this problem is.
Based on my experience, this issue could occur if the "Performance Logs and
Alerts" service runs as "Network Service", which is member of "Performance
Log Users" local user group, does not have enough permission to SQL setup
folder.
SQL Setup grants read/execute permissions to "Performance Log Users" local
user group for the DLL only. "Performance Log Users" doesnt have any
permissions for the containing folder. Granting "List folder contents"
permission to "Performance Log Users" for the containing folder (SQL Server
binn directory) may fix this problem:
D:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\bin
D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin
If you have any update or the issue is not resolved, please feel free to
let's know. I look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks. That solved the problem.
--
LehrSJ
""privatenews"" wrote:

> Hello LehrSJ,
> I understand that you found some SQL related events on a SQL 2005 SP1 64bi
t
> server, and you'd like to know what this problem is.
> Based on my experience, this issue could occur if the "Performance Logs an
d
> Alerts" service runs as "Network Service", which is member of "Performance
> Log Users" local user group, does not have enough permission to SQL setup
> folder.
> SQL Setup grants read/execute permissions to "Performance Log Users" local
> user group for the DLL only. "Performance Log Users" doesn’t have any
> permissions for the containing folder. Granting "List folder contents"
> permission to "Performance Log Users" for the containing folder (SQL Serve
r
> binn directory) may fix this problem:
> D:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\bin
> D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin
> If you have any update or the issue is not resolved, please feel free to
> let's know. I look forward to your reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ========================================
==========
> Get notification to my posts through email? Please refer to
> l]
> ications
> <[url]http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx" target="_blank">http://msdn.microsoft.com/subscript...ps/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscript...rt/default.aspx>.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>|||I was having this problem as well on a 32 bit system and that fixed it.
Can you explain why that fixed it? I'm asking because I was also having
2 other problems that I think this fixed as well.
first one: There is a Java program that inserts updates and deletes
records in a very large table on the sql server. It spawns 12 processes
that each have a connection to the DB and every time this program ran,
2 of them would hang up and would not receive any errors. I looked and
they were no longer connected.
second one: The users of this server have pocket pcs that connect using
sql ce server with RDA. They use an app that we wrote to replicate
their data. Along with all the pushing and pulling of tables, there is
one stored procedure that the client runs on the server. Apparently
randomly this stored procedure stops working for about 30 minutes at a
time. What happens on the client is when it calls that sp, it just
hangs there maintaining it's connection until all the sudden the sp
start working again. During the 30 minutes nobody can run the sp.
Both of these problems did not exist before we got Error 59 or after it
was fixed.
Does anybody have any clue as to why this would fix these 2 problems or
has anybody experienced anything like this?
thanks,
cob

'microsoft.sqlserver.batchparser' is malformed or not a pure .NET assembly.

Hi all,

I have a small dll that use the SQL Server 2005 SMO library. SQL Server 2005 has SP 1 installed. When I tried to register the assembly with the followin command, I get the error shown. If I remove all references to SMO, the assembly registered fine.
I really need help on this.

Thanks in advance.

CREATE ASSEMBLY ACDataBridge
FROM
'H:\User\Development\Projects\Applications\ACDataBridge\bin\Debug\Projects.Applications.ACDataBridge.dll'
WITH PERMISSION_SET = UNSAFE

Msg 6544, Level 16, State 1, Line 1
CREATE ASSEMBLY for assembly 'Projects.Applications.ACDataBridge' failed because assembly 'microsoft.sqlserver.batchparser' is malformed or not a pure .NET assembly.
Unverifiable PE Header/native stub.

Hi,

Unfortunately in SqlServer 2005 we do not support loading SMO in SQLCLR. If you want to build your assembly for dual use (i.e. both inside SQLCLR and on the client) you can load SMO via reflection. This works in a rather narrow set of scenarios though, for the next version of SqlServer we are looking at making sure that SMO loads and works inside SQLCLR.

Regards,

Ciprian Gerea, SqlServer SDE

|||

Hi Ciprian,

Thank you so much for your repy. For a minute, I thought this post would never be answere. Your sggestion sounds good, but I have tried loading assebly dynamically in SQLCLR code and it was failing; here is one:

I use Assembly.LoadFrom("test.dll"); to dynamically load a dll in a SQL CLR pocedure method, but I get this error:

System.IO.FileLoadException: LoadFrom(), LoadFile(), Load(byte[]) and LoadModule() have been disabled by the host.

First method:
I have also tried to activate a managed COM, and it fails:

//Get IDispatch Interface
Type objMethodType = Type.GetTypeFromProgID("CLRServer.CServerObject");
//Create Instance
object objMethod = Activator.CreateInstance(objMethodType);
//Make Array of Arguments
object[] myArguments =
{
strKeySet, strTarget, strMetadata
};
//Invoke Add Method
strReturnParam = (String)objMethodType.InvokeMember(
"Process", BindingFlags.InvokeMethod, null, objMethod, myArguments);

Second method:
I tried to activate an unmanaged COM, which in turn, calls a method in the above managed COM:
The instance of the unmanaged COM was created succesfully, but the method call failed with COMExeption

//Get IDispatch Interface
Type objMethodType = Type.GetTypeFromProgID("CComNativeLink2.CComNativeLink.1");
//Create Instance
object objMethod = Activator.CreateInstance(objMethodType);
//Make Array of Arguments
object[] myArguments =
{
strKeySet, strTarget, strMetadata
};
//Invoke Add Method
strReturnParam = (String)objMethodType.InvokeMember(
"ProcessData", BindingFlags.InvokeMethod, null, objMethod, myArguments);

Any idea?

Can you give a sample of your suggestion?

Thanks in advance

|||

I think that Assembly.LoadFrom fails to access the disk if you are registred as SAFE. The reason is that registering as SAFE only gives you only execution privileges, not file access. You should use Assembly.Load instead. But let me make something clear - this does not mean that you will be able to use SMO inside SQLCLR this way, it's just a way to load SMO only when you're not inside SQLCLR and keep the rest of your application code identical, as much as possible.

As for the COM objects, they are also not supported inside SQLCLR. You can of course use the sp_OACreate & Co. and load the COM stuff into the native space, but this has drawbacks as far as reliability and performance. If the native objects loads a managed assembly it will still be subject to the same restrictions.

Ciprian

|||

Hi Ciprian,

Thank you so much for clarifying that. Unfortunately, I had already tried sp_OACreate and it failed also due to managed COM. I guess my only option left would be extended stored procedure and managed COM. Or is that going to fail also?

|||

I'm afraid it will also fail. There is currently no way you can run SMO inside SQLCLR.

Ciprian

|||Is there another way to script out objects from within SQL Server?

This is very disappointing.

'microsoft.sqlserver.batchparser' is malformed or not a pure .NET assembly.

Hi all,

I have a small dll that use the SQL Server 2005 SMO library. SQL Server 2005 has SP 1 installed. When I tried to register the assembly with the followin command, I get the error shown. If I remove all references to SMO, the assembly registered fine.
I really need help on this.

Thanks in advance.

CREATE ASSEMBLY ACDataBridge
FROM
'H:\User\Development\Projects\Applications\ACDataBridge\bin\Debug\Projects.Applications.ACDataBridge.dll'
WITH PERMISSION_SET = UNSAFE

Msg 6544, Level 16, State 1, Line 1
CREATE ASSEMBLY for assembly 'Projects.Applications.ACDataBridge' failed because assembly 'microsoft.sqlserver.batchparser' is malformed or not a pure .NET assembly.
Unverifiable PE Header/native stub.

Hi,

Unfortunately in SqlServer 2005 we do not support loading SMO in SQLCLR. If you want to build your assembly for dual use (i.e. both inside SQLCLR and on the client) you can load SMO via reflection. This works in a rather narrow set of scenarios though, for the next version of SqlServer we are looking at making sure that SMO loads and works inside SQLCLR.

Regards,

Ciprian Gerea, SqlServer SDE

|||

Hi Ciprian,

Thank you so much for your repy. For a minute, I thought this post would never be answere. Your sggestion sounds good, but I have tried loading assebly dynamically in SQLCLR code and it was failing; here is one:

I use Assembly.LoadFrom("test.dll"); to dynamically load a dll in a SQL CLR pocedure method, but I get this error:

System.IO.FileLoadException: LoadFrom(), LoadFile(), Load(byte[]) and LoadModule() have been disabled by the host.

First method:
I have also tried to activate a managed COM, and it fails:

//Get IDispatch Interface
Type objMethodType = Type.GetTypeFromProgID("CLRServer.CServerObject");
//Create Instance
object objMethod = Activator.CreateInstance(objMethodType);
//Make Array of Arguments
object[] myArguments =
{
strKeySet, strTarget, strMetadata
};
//Invoke Add Method
strReturnParam = (String)objMethodType.InvokeMember(
"Process", BindingFlags.InvokeMethod, null, objMethod, myArguments);

Second method:
I tried to activate an unmanaged COM, which in turn, calls a method in the above managed COM:
The instance of the unmanaged COM was created succesfully, but the method call failed with COMExeption

//Get IDispatch Interface
Type objMethodType = Type.GetTypeFromProgID("CComNativeLink2.CComNativeLink.1");
//Create Instance
object objMethod = Activator.CreateInstance(objMethodType);
//Make Array of Arguments
object[] myArguments =
{
strKeySet, strTarget, strMetadata
};
//Invoke Add Method
strReturnParam = (String)objMethodType.InvokeMember(
"ProcessData", BindingFlags.InvokeMethod, null, objMethod, myArguments);

Any idea?

Can you give a sample of your suggestion?

Thanks in advance

|||

I think that Assembly.LoadFrom fails to access the disk if you are registred as SAFE. The reason is that registering as SAFE only gives you only execution privileges, not file access. You should use Assembly.Load instead. But let me make something clear - this does not mean that you will be able to use SMO inside SQLCLR this way, it's just a way to load SMO only when you're not inside SQLCLR and keep the rest of your application code identical, as much as possible.

As for the COM objects, they are also not supported inside SQLCLR. You can of course use the sp_OACreate & Co. and load the COM stuff into the native space, but this has drawbacks as far as reliability and performance. If the native objects loads a managed assembly it will still be subject to the same restrictions.

Ciprian

|||

Hi Ciprian,

Thank you so much for clarifying that. Unfortunately, I had already tried sp_OACreate and it failed also due to managed COM. I guess my only option left would be extended stored procedure and managed COM. Or is that going to fail also?

|||

I'm afraid it will also fail. There is currently no way you can run SMO inside SQLCLR.

Ciprian

|||Is there another way to script out objects from within SQL Server?

This is very disappointing.

Microsoft.ReportingServices.UI ?

does microsoft give away the source for the reporting service ui?
usually installed in
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\Pages
I would love to see the code for this page
<%@. Register TagPrefix="MSRS" Namespace="Microsoft.ReportingServices.UI"
Assembly="ReportingServicesWebUserInterface" %>
<%@. Page language="c#" Codebehind="DataSource.aspx.cs"
AutoEventWireup="false"
Inherits="Microsoft.ReportingServices.UI.DataSourcePage" %>
If they don't give this code away they should it would be very very helpfull.We all wish. But there is some sample UI code you can download.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"letuce dance" <letucedance@.discussions.microsoft.com> wrote in message
news:8A7902B5-5496-458B-B323-013B9724EF53@.microsoft.com...
> does microsoft give away the source for the reporting service ui?
> usually installed in
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\Pages
> I would love to see the code for this page
> <%@. Register TagPrefix="MSRS" Namespace="Microsoft.ReportingServices.UI"
> Assembly="ReportingServicesWebUserInterface" %>
> <%@. Page language="c#" Codebehind="DataSource.aspx.cs"
> AutoEventWireup="false"
> Inherits="Microsoft.ReportingServices.UI.DataSourcePage" %>
> If they don't give this code away they should it would be very very
> helpfull.

Microsoft.Data.Odbc on 64-Bit Server

Hi!

Today we installed our ASP.NET Application on a 64-bit server for the first time. We got the error'Unable to find entry point named 'InterlockedIncrement' in DLL 'kernel32.dll''.

This error comes when we make a database query using Microsoft.Data.Odbc. I think it does not run on 64-bit machines.

Does anybody know something about this?

KaaN

I don't know why you need it with ODBC datasource but the link below Microsoft explains the reason for you error. Hope this helps.

(The variable pointed to by the Addend parameter must be aligned on a 32-bit boundary; otherwise, this function will behave unpredictably on multiprocessor x86 systems and any non-x86 systems.)

http://msdn2.microsoft.com/en-us/library/ms683614.aspx

|||

Thanks for your answer.

Actually I don't need this xxIncrement method, I only need the .Net Odbc Provider and probably this provider is using this function. Now I have to refactor my code to native providers or find another .Net ODBC Provider.

Microsoft Web Data Administrator

I have download this Front End because MSDE doesnt ship with an Visual
Interface,
i have installed MSDE2000 i believe is MSDE200a
when i installed i pass the SAPWD parameters to the setup and all was
fine...
but i cant loggin with the user SA with no password.
Even if i made an UDL File, i cant connect with that user, i have to check
login USING WINDOWS NT Integrated Security...
:S
how can i connect with the SA user with no password
________________________________
Juan Carlos Garcia
Santo Domingo, Republica Dominicana
hi Juan,
"Juan Carlos Garcia" <AskMePlease@.AskMePlease.Com> ha scritto nel messaggio
news:O%23buOQdmEHA.704@.TK2MSFTNGP09.phx.gbl...
> I have download this Front End because MSDE doesnt ship with an Visual
> Interface,
> i have installed MSDE2000 i believe is MSDE200a
> when i installed i pass the SAPWD parameters to the setup and all was
> fine...
> but i cant loggin with the user SA with no password.
> Even if i made an UDL File, i cant connect with that user, i have to check
> login USING WINDOWS NT Integrated Security...
> :S
> how can i connect with the SA user with no password
if you can not connect using SQL Server authentication at all, this usually
means that only Windows Authentication is enabled for that instance, and you
have to manually enable it, modifying a Windows registry key, as explained
in http://support.microsoft.com/default...b;en-us;285097
if you can connect with SQL Server authentication, but want to clear the sa
password to a blank password, you can execute
EXEC sp_password @.new = 'am301065' , @.loginame = 'sa'
but I strongly warn you not to do it... a strong password always is your
best friend
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Jaun
Doesn't MSDE2000a include SP3a and doesn't SP3a not work with blank passwords?
Rich
"Andrea Montanari" wrote:

> hi Juan,
> "Juan Carlos Garcia" <AskMePlease@.AskMePlease.Com> ha scritto nel messaggio
> news:O%23buOQdmEHA.704@.TK2MSFTNGP09.phx.gbl...
> if you can not connect using SQL Server authentication at all, this usually
> means that only Windows Authentication is enabled for that instance, and you
> have to manually enable it, modifying a Windows registry key, as explained
> in http://support.microsoft.com/default...b;en-us;285097
> if you can connect with SQL Server authentication, but want to clear the sa
> password to a blank password, you can execute
> EXEC sp_password @.new = 'am301065' , @.loginame = 'sa'
> but I strongly warn you not to do it... a strong password always is your
> best friend
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Thks.. for the help for both of you... but finally i have to Uninstall and
Install again passing this parameters : setup SAPWD = "****"
SECURITYMODE=SQL
and know its working... :D
thks.. again... see you..
________________________________
Juan Carlos Garcia
Santo Domingo, Republica Dominicana
"Richard Yeo" <RichardYeo@.discussions.microsoft.com> escribi en el mensaje
news:D66748B5-F213-4251-9B5F-E050B681AD08@.microsoft.com...
> Jaun
> Doesn't MSDE2000a include SP3a and doesn't SP3a not work with blank
passwords?[vbcol=seagreen]
> Rich
>
> "Andrea Montanari" wrote:
messaggio[vbcol=seagreen]
check[vbcol=seagreen]
usually[vbcol=seagreen]
you[vbcol=seagreen]
explained[vbcol=seagreen]
sa[vbcol=seagreen]
|||hi Richard,
"Richard Yeo" <RichardYeo@.discussions.microsoft.com> ha scritto nel
messaggio news:D66748B5-F213-4251-9B5F-E050B681AD08@.microsoft.com...
> Jaun
> Doesn't MSDE2000a include SP3a and doesn't SP3a not work with blank
passwords?
yes it does, but, at install time, you have to force the BLANKSAPWD=1
parameter in order to accept it... an again, I strongly recommend not to
allow blank pwd policies
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

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 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 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 Report Designer

Hi, I have installed SQL Server 2000 and Reporting Services 2005 and Visual Studio 2003 all works OK but I need to create a report with the Microsoft SQL Server Report Designer 2005 and it doesn't appear in my VS, someone could help me with this?

Marcos.

Look in [All Programs][Microsoft SQL Server 2005] on the start menu and see if you have SQL Server Business Intelligence Development Studio. If it is not there, go through the following steps Dan Jones supplied in this other thread:

You should make sure that Visual Studio is still installed. If you didn't previously have VS installed, the BI Dev Studio installation will install a VS shell called Visual Studio Premier Partner Edition. Look in Add or Remove Programs for an entry like this. If you don't find any entry for Visual Studio go to the location for SQL Server setup and run .\Tools\Setup\vs_setup.exe. This will install the VS Shell. After this is installed repair the BI Studio installation by running the following from the command line from the .\Tools directory: start /wait setup.exe /qb REINSTALL=SQL_WarehouseDevWorkbench REINSTALLMODE=OMUS

Good luck! Let us know how it turns out.

Larry Smithmier

|||

I install the VS Premier PArtener Ed. but my VS not shows the option to create a new BI project, look the link below.

http://i203.photobucket.com/albums/aa119/mcssnt/My_Screen.jpg

Marcos

|||

You need to install the SQL Server client components to get the Report Project to appear in VS.NET. Alternatively, you can use the Business Intelligence Development Studio which is included in the SQL Server client components.

|||

Thanks, when I try to install the SQL clien components the setup shows: 'An installation package for the product Microsoft SQL Server Native Client cannont be found. Try the installation again using a valid copy of the installation packege 'sqlcli.msi'.' If I install the complete VS 2005 developer ed, this help to fix the issue?

|||

There is a standalone redistributable for SQL Server Native Client. The server portion of the setup installs it as a prerequisite as well.

|||

I have finished to install the Clien Components, I ran the Task Manager and end the process tree of the sqlserver and the explorer.exe and then start again the explorer.exe and ran the setup with this I can install the client components without message error.

Many thanks to all.

Marcos

Microsoft SQL Server Mobile Edition data source

i just installed a copy of microsoft sql server 2005 in my pc and decided to follow the newbie's guide:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true
anyway, on the 5th exercise wherein i'm supposed to add a new data connection through the server explorer.. when i chose the option of adding a new data source and was prompted to select a data source i couldnt find the Microsoft SQL Server Mobile Edition data source..
is there anything else that i need to download in order to have that data source?

1) Did your installation include "SQL Server 2005 Mobile Edition". Can you see SQL Mobile traces in "Add/Remove Programs" directory. Some thing like "SQL Server Mobile Developer Tools".

2) If yes, then can you please follow the thread@. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=260599&SiteID=1, and see if it helps you out.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||uh yeah. but mine says "Microsoft SQL Server Mobile 2005 Mobile [ENU] Server Tools" i got the sql server 2005 mobile edition by accessing the sqlce30setupen.msi file. also i already tried to add the following lines to the machine.config file but i still couldnt find it when i open vs studio 2005. anyway, if worst comes to worst and i cant figure this one out would you happen to know how i would configure the database connection for a pocket pc through the use of vs.net 2003?

<add name="SQL Server CE Data Provider" invariant="Microsoft.SqlServerCe.Client" description=".NET Framework Data Provider for Microsoft SQL Server 2005 Mobile Edition" type="Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />|||

Hmm...it looks like SQL Mobile Developer tools were not installed. Server Tools are not needed for you, they are meant for synchronization of SQL Mobile database with SQL Server. If you dont have Developer Tools, try installing the SQL Mobile Developer tools from the following location of your VS 2005 Disk: wcu\SQLCE\sqlmobile30devtoolsxxx.msi

The xxx in the MSI name stand for the locale, for english it would be 'enu'.

Let me know installing that worked for you.

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||Dear Laxmi....

I also have the same problem and I tried to install the SQL Mobile Developer tools from VS 2005, but the location is not avalaible in the CD. I used VS PRo 2005.

Please help me because I have a project to write program for My Mobile Application that's need to connect to database.

Microsoft SQL Server Mobile Edition data source

i just installed a copy of microsoft sql server 2005 in my pc and decided to follow the newbie's guide:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true

anyway, on the 5th exercise wherein i'm supposed to add a new data

connection through the server explorer.. when i chose the option of

adding a new data source and was prompted to select a data source i

couldnt find the Microsoft SQL Server Mobile Edition data source..

is there anything else that i need to download in order to have that data source?

1) Did your installation include "SQL Server 2005 Mobile Edition". Can you see SQL Mobile traces in "Add/Remove Programs" directory. Some thing like "SQL Server Mobile Developer Tools".

2) If yes, then can you please follow the thread@. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=260599&SiteID=1, and see if it helps you out.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||uh yeah. but mine says "Microsoft SQL Server Mobile 2005 Mobile [ENU]

Server Tools" i got the sql server 2005 mobile edition by accessing the

sqlce30setupen.msi file. also i already tried to add the

following lines to the machine.config file but i still couldnt find it

when i open vs studio 2005. anyway, if worst comes to worst and i

cant figure this one out would you happen to know how i would configure

the database connection for a pocket pc through the use of vs.net 2003?
<add

name="SQL Server CE Data Provider"

invariant="Microsoft.SqlServerCe.Client" description=".NET Framework

Data Provider for Microsoft SQL Server 2005 Mobile Edition"

type="Microsoft.SqlServerCe.Client.SqlCeClientFactory,

Microsoft.SqlServerCe.Client, Version=9.0.242.0, Culture=neutral,

PublicKeyToken=89845dcd8080cc91" />|||

Hmm...it looks like SQL Mobile Developer tools were not installed. Server Tools are not needed for you, they are meant for synchronization of SQL Mobile database with SQL Server. If you dont have Developer Tools, try installing the SQL Mobile Developer tools from the following location of your VS 2005 Disk: wcu\SQLCE\sqlmobile30devtoolsxxx.msi

The xxx in the MSI name stand for the locale, for english it would be 'enu'.

Let me know installing that worked for you.

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||Dear Laxmi....

I also have the same problem and I tried to install the SQL Mobile Developer tools from VS 2005, but the location is not avalaible in the CD. I used VS PRo 2005.

Please help me because I have a project to write program for My Mobile Application that's need to connect to database.

Microsoft SQL Server Management Studio problem

The 'Reports' button on the Summary screen is disabled. How can I get it enabled so that I can view the database dashboard?

I have installed SQL Server 2005 Developer Edition with Reporting services

ThanksThe Reports button is context sensitive. In the object browser, click/highlight your database, then the reports button should be enabled. A wrote in message news:61cb2041-e52f-4503-b439-60aa3ba7eefc@.discussions.microsoft.com...
> The 'Reports' button on the Summary screen is disabled. How can I get it
> enabled so that I can view the database dashboard? >
> I have installed SQL Server 2005 Developer Edition with Reporting
> services >
> Thanks
>|||That is right. It is context specific. It is enabled when a DB is selected and similarly, the report button is enabled when server is selected to see server dashbord.