Can't start sql server 2000, error: "use sql 2005 management tools" !!!!

hi .everyone !

i have ms visual studio 2005 with sql sever 2005 management tools

anyway .. i want to use and install sql server 2000 in this machine .. i tried to install it, but when i tried to connect to the server .. it gives me this error:

"you must use sql server 2005 management tools to connect to this server"

can you help me ? plz !?

no one can help me ?

any suggestion ? help ? :(

Can't send operator email in SQL Sever 2005

I have set up Database Mail
I have sent a test message successfully
I have set up a Operator
When I create a test job to send a test message to the operator the
TSQL is
EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris Auer',@.body=N'wewqe'
When I run that query I get
Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 94
No global profile is configured. Specify a profile name in the
@.profile_name parameter.
In the job log I have this
Executing the query "EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris
Auer',@.body=N'wewqe'
" failed with the following error: "No global profile is configured.
Specify a profile name in the @.profile_name parameter.". Possible
failure reasons: Problems with the query, "ResultSet" property not set
correctly, parameters not set correctly, or connection not established
correctly.
What is a global profile?
I have already made the registry change to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\SQLServerAgent
I made DatabaseMailProfile my default profile name in Database Mail and
I made UseDatabaseMail = 1
Any ideas, thanks. This is driving me up a wall.'
Chris Auer
Looks like you only need to specify a profile name or define a default
profile.
Right-click Database Mail, select Configure Database Mail and select Manage
profile security. Here you have the choice to configure your profiles as
public, private and/or default.
If you do not have a default profile configured you will need to specify the
@.profile_name parameter. This is the same name under 'Profile name' on the
Database Mail Configuration Wizard.
Also, take a look at 'Database Mail [SQL Server], security on BOL.
Ben Nevarez, MCDBA, OCP
"Chris Auer" <chris.auer@.gmail.com> wrote in message
news:1132958108.969902.311470@.g44g2000cwa.googlegr oups.com...
>I have set up Database Mail
> I have sent a test message successfully
> I have set up a Operator
> When I create a test job to send a test message to the operator the
> TSQL is
> EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris Auer',@.body=N'wewqe'
> When I run that query I get
> Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 94
> No global profile is configured. Specify a profile name in the
> @.profile_name parameter.
> In the job log I have this
> Executing the query "EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris
> Auer',@.body=N'wewqe'
> " failed with the following error: "No global profile is configured.
> Specify a profile name in the @.profile_name parameter.". Possible
> failure reasons: Problems with the query, "ResultSet" property not set
> correctly, parameters not set correctly, or connection not established
> correctly.
>
> What is a global profile?
> I have already made the registry change to
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> Server\MSSQL.1\SQLServerAgent
> I made DatabaseMailProfile my default profile name in Database Mail and
> I made UseDatabaseMail = 1
> Any ideas, thanks. This is driving me up a wall.'
> Chris Auer
>
|||I also have the exact same problem, and is driving me nuts too. I have
created a default, private profile for the agent to use, however it still
fails.
I get the same error message. I can send database mail, but the agent fails.
I've tried public default profiles and they fail too. The agent account is
setup in msdb in the DatabaseMailUser role.
The interseting thing is that the 'Test' button is dimmed on the SQL Agent,
Alert System, Mail Session page even though the correct profile is selected!
Please, any help will be greatly appreciated.
Jim
"Ben Nevarez" wrote:

> Looks like you only need to specify a profile name or define a default
> profile.
> Right-click Database Mail, select Configure Database Mail and select Manage
> profile security. Here you have the choice to configure your profiles as
> public, private and/or default.
> If you do not have a default profile configured you will need to specify the
> @.profile_name parameter. This is the same name under 'Profile name' on the
> Database Mail Configuration Wizard.
> Also, take a look at 'Database Mail [SQL Server], security on BOL.
> Ben Nevarez, MCDBA, OCP
>
> "Chris Auer" <chris.auer@.gmail.com> wrote in message
> news:1132958108.969902.311470@.g44g2000cwa.googlegr oups.com...
>
>

Can't send operator email in SQL Sever 2005

I have set up Database Mail
I have sent a test message successfully
I have set up a Operator
When I create a test job to send a test message to the operator the
TSQL is
EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris Auer',@.body=N'wewqe'
When I run that query I get
Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 94
No global profile is configured. Specify a profile name in the
@.profile_name parameter.
In the job log I have this
Executing the query "EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris
Auer',@.body=N'wewqe'
" failed with the following error: "No global profile is configured.
Specify a profile name in the @.profile_name parameter.". Possible
failure reasons: Problems with the query, "ResultSet" property not set
correctly, parameters not set correctly, or connection not established
correctly.
What is a global profile?
I have already made the registry change to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\SQLServerAgent
I made DatabaseMailProfile my default profile name in Database Mail and
I made UseDatabaseMail = 1
Any ideas, thanks. This is driving me up a wall.'
Chris AuerLooks like you only need to specify a profile name or define a default
profile.
Right-click Database Mail, select Configure Database Mail and select Manage
profile security. Here you have the choice to configure your profiles as
public, private and/or default.
If you do not have a default profile configured you will need to specify the
@.profile_name parameter. This is the same name under 'Profile name' on the
Database Mail Configuration Wizard.
Also, take a look at 'Database Mail [SQL Server], security on BOL.
Ben Nevarez, MCDBA, OCP
"Chris Auer" <chris.auer@.gmail.com> wrote in message
news:1132958108.969902.311470@.g44g2000cwa.googlegroups.com...
>I have set up Database Mail
> I have sent a test message successfully
> I have set up a Operator
> When I create a test job to send a test message to the operator the
> TSQL is
> EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris Auer',@.body=N'wewqe'
> When I run that query I get
> Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 94
> No global profile is configured. Specify a profile name in the
> @.profile_name parameter.
> In the job log I have this
> Executing the query "EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris
> Auer',@.body=N'wewqe'
> " failed with the following error: "No global profile is configured.
> Specify a profile name in the @.profile_name parameter.". Possible
> failure reasons: Problems with the query, "ResultSet" property not set
> correctly, parameters not set correctly, or connection not established
> correctly.
>
> What is a global profile?
> I have already made the registry change to
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> Server\MSSQL.1\SQLServerAgent
> I made DatabaseMailProfile my default profile name in Database Mail and
> I made UseDatabaseMail = 1
> Any ideas, thanks. This is driving me up a wall.'
> Chris Auer
>|||I also have the exact same problem, and is driving me nuts too. I have
created a default, private profile for the agent to use, however it still
fails.
I get the same error message. I can send database mail, but the agent fails.
I've tried public default profiles and they fail too. The agent account is
setup in msdb in the DatabaseMailUser role.
The interseting thing is that the 'Test' button is dimmed on the SQL Agent,
Alert System, Mail Session page even though the correct profile is selected!
Please, any help will be greatly appreciated.
Jim
"Ben Nevarez" wrote:
> Looks like you only need to specify a profile name or define a default
> profile.
> Right-click Database Mail, select Configure Database Mail and select Manage
> profile security. Here you have the choice to configure your profiles as
> public, private and/or default.
> If you do not have a default profile configured you will need to specify the
> @.profile_name parameter. This is the same name under 'Profile name' on the
> Database Mail Configuration Wizard.
> Also, take a look at 'Database Mail [SQL Server], security on BOL.
> Ben Nevarez, MCDBA, OCP
>
> "Chris Auer" <chris.auer@.gmail.com> wrote in message
> news:1132958108.969902.311470@.g44g2000cwa.googlegroups.com...
> >I have set up Database Mail
> > I have sent a test message successfully
> > I have set up a Operator
> >
> > When I create a test job to send a test message to the operator the
> > TSQL is
> >
> > EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris Auer',@.body=N'wewqe'
> >
> > When I run that query I get
> >
> > Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 94
> > No global profile is configured. Specify a profile name in the
> > @.profile_name parameter.
> >
> > In the job log I have this
> >
> > Executing the query "EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris
> > Auer',@.body=N'wewqe'
> > " failed with the following error: "No global profile is configured.
> > Specify a profile name in the @.profile_name parameter.". Possible
> > failure reasons: Problems with the query, "ResultSet" property not set
> > correctly, parameters not set correctly, or connection not established
> > correctly.
> >
> >
> > What is a global profile?
> >
> > I have already made the registry change to
> > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> > Server\MSSQL.1\SQLServerAgent
> > I made DatabaseMailProfile my default profile name in Database Mail and
> > I made UseDatabaseMail = 1
> >
> > Any ideas, thanks. This is driving me up a wall.'
> >
> > Chris Auer
> >
>
>sql

Can't send operator email in SQL Sever 2005

I have set up Database Mail
I have sent a test message successfully
I have set up a Operator
When I create a test job to send a test message to the operator the
TSQL is
EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris Auer',@.body=N'wewqe'
When I run that query I get
Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 94
No global profile is configured. Specify a profile name in the
@.profile_name parameter.
In the job log I have this
Executing the query "EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris
Auer',@.body=N'wewqe'
" failed with the following error: "No global profile is configured.
Specify a profile name in the @.profile_name parameter.". Possible
failure reasons: Problems with the query, "ResultSet" property not set
correctly, parameters not set correctly, or connection not established
correctly.
What is a global profile?
I have already made the registry change to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQL.1\SQLServerAgent
I made DatabaseMailProfile my default profile name in Database Mail and
I made UseDatabaseMail = 1
Any ideas, thanks. This is driving me up a wall.'
Chris AuerLooks like you only need to specify a profile name or define a default
profile.
Right-click Database Mail, select Configure Database Mail and select Manage
profile security. Here you have the choice to configure your profiles as
public, private and/or default.
If you do not have a default profile configured you will need to specify the
@.profile_name parameter. This is the same name under 'Profile name' on the
Database Mail Configuration Wizard.
Also, take a look at 'Database Mail [SQL Server], security on BOL.
Ben Nevarez, MCDBA, OCP
"Chris Auer" <chris.auer@.gmail.com> wrote in message
news:1132958108.969902.311470@.g44g2000cwa.googlegroups.com...
>I have set up Database Mail
> I have sent a test message successfully
> I have set up a Operator
> When I create a test job to send a test message to the operator the
> TSQL is
> EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris Auer',@.body=N'wewqe'
> When I run that query I get
> Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 94
> No global profile is configured. Specify a profile name in the
> @.profile_name parameter.
> In the job log I have this
> Executing the query "EXECUTE msdb.dbo.sp_notify_operator @.name=N'Chris
> Auer',@.body=N'wewqe'
> " failed with the following error: "No global profile is configured.
> Specify a profile name in the @.profile_name parameter.". Possible
> failure reasons: Problems with the query, "ResultSet" property not set
> correctly, parameters not set correctly, or connection not established
> correctly.
>
> What is a global profile?
> I have already made the registry change to
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
> Server\MSSQL.1\SQLServerAgent
> I made DatabaseMailProfile my default profile name in Database Mail and
> I made UseDatabaseMail = 1
> Any ideas, thanks. This is driving me up a wall.'
> Chris Auer
>|||I also have the exact same problem, and is driving me nuts too. I have
created a default, private profile for the agent to use, however it still
fails.
I get the same error message. I can send database mail, but the agent fails
.
I've tried public default profiles and they fail too. The agent account is
setup in msdb in the DatabaseMailUser role.
The interseting thing is that the 'Test' button is dimmed on the SQL Agent,
Alert System, Mail Session page even though the correct profile is selected!
Please, any help will be greatly appreciated.
Jim
"Ben Nevarez" wrote:

> Looks like you only need to specify a profile name or define a default
> profile.
> Right-click Database Mail, select Configure Database Mail and select Manag
e
> profile security. Here you have the choice to configure your profiles as
> public, private and/or default.
> If you do not have a default profile configured you will need to specify t
he
> @.profile_name parameter. This is the same name under 'Profile name' on the
> Database Mail Configuration Wizard.
> Also, take a look at 'Database Mail [SQL Server], security on BOL.
> Ben Nevarez, MCDBA, OCP
>
> "Chris Auer" <chris.auer@.gmail.com> wrote in message
> news:1132958108.969902.311470@.g44g2000cwa.googlegroups.com...
>
>

Cant see Db created inside VS 2005?

When I create a new Sql Sever 2005 express database inside of the VS 2005 Pro IDE I cant see the database from the Management Tool (Sql Srvr Express Management Studio). Is this normal? I can "attach" it and see it, but I wanted to make sure my environment was working correctly.

Thanks in advance for any input.

Tim

Hi there,

As far as I am aware, this is the correct behaviour. From memory, the databases you create via the IDE are basically local to the project you created them in.

However, as you have discovered, these are still standard .mdf and .ldf files and can be attached as to be visible as one of the database on your SQL Server Express instance.

Hope that helps a bit or sheds some light on things, but sorry if it doesn't
|||

To be clear, when you create a database in VS using Add | New Item | Database, it is an embedded project database as Nate suggests. This database uses a User Instance connection to manage auto-attaching the database to the application at runtime.

If you turn around and manually attach the database to the main instance of SQL Express, you application will fail when you run it as it will attempt to auto-attach the database to the User Instance, but the file will be locked so it won't be attachable within the application.

There are a number of discussions already in the forums and a white paper about User Instances if you want more info.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

Cant new SQL sever registration

when i try new SQL sever registration it says does not exist or acces denied
"Robert" <Robert@.discussions.microsoft.com> wrote in message
news:0F713BC9-1452-41D1-A390-269A5FD8816A@.microsoft.com...
> when i try new SQL sever registration it says does not exist or acces
> denied
Can you connect to the other Server using other means? Can you ping the
other server?
Can you connect to the other server using Query Analyzer?
Is the MSSQLServer service running on the other server?
Just a few things to check first.
Rick Sawtell
MCT, MCSD, MCDBA
|||im not trying to JOIN A SEVER im trying to MAKE sever
"Rick Sawtell" wrote:

> "Robert" <Robert@.discussions.microsoft.com> wrote in message
> news:0F713BC9-1452-41D1-A390-269A5FD8816A@.microsoft.com...
> Can you connect to the other Server using other means? Can you ping the
> other server?
> Can you connect to the other server using Query Analyzer?
> Is the MSSQLServer service running on the other server?
> Just a few things to check first.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
>
|||When you use Enterprise Manager to register a server, that's
intended for connecting to an existing SQL Server instance.
If you want to create another new instance, you need to
install SQL Server from the installation CD.
-Sue
On Thu, 27 Jan 2005 11:37:01 -0800, Robert
<Robert@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>im not trying to JOIN A SEVER im trying to MAKE sever
>"Rick Sawtell" wrote:

Cant new SQL sever registration

when i try new SQL sever registration it says does not exist or acces denied"Robert" <Robert@.discussions.microsoft.com> wrote in message
news:0F713BC9-1452-41D1-A390-269A5FD8816A@.microsoft.com...
> when i try new SQL sever registration it says does not exist or acces
> denied
Can you connect to the other Server using other means? Can you ping the
other server?
Can you connect to the other server using Query Analyzer?
Is the MSSQLServer service running on the other server?
Just a few things to check first.
Rick Sawtell
MCT, MCSD, MCDBA|||im not trying to JOIN A SEVER im trying to MAKE sever
"Rick Sawtell" wrote:
> "Robert" <Robert@.discussions.microsoft.com> wrote in message
> news:0F713BC9-1452-41D1-A390-269A5FD8816A@.microsoft.com...
> > when i try new SQL sever registration it says does not exist or acces
> > denied
> Can you connect to the other Server using other means? Can you ping the
> other server?
> Can you connect to the other server using Query Analyzer?
> Is the MSSQLServer service running on the other server?
> Just a few things to check first.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
>|||When you use Enterprise Manager to register a server, that's
intended for connecting to an existing SQL Server instance.
If you want to create another new instance, you need to
install SQL Server from the installation CD.
-Sue
On Thu, 27 Jan 2005 11:37:01 -0800, Robert
<Robert@.discussions.microsoft.com> wrote:
>im not trying to JOIN A SEVER im trying to MAKE sever
>"Rick Sawtell" wrote:
>> "Robert" <Robert@.discussions.microsoft.com> wrote in message
>> news:0F713BC9-1452-41D1-A390-269A5FD8816A@.microsoft.com...
>> > when i try new SQL sever registration it says does not exist or acces
>> > denied
>> Can you connect to the other Server using other means? Can you ping the
>> other server?
>> Can you connect to the other server using Query Analyzer?
>> Is the MSSQLServer service running on the other server?
>> Just a few things to check first.
>>
>> Rick Sawtell
>> MCT, MCSD, MCDBA
>>
>>
>>

Cant new SQL sever registration

when i try new SQL sever registration it says does not exist or acces denied"Robert" <Robert@.discussions.microsoft.com> wrote in message
news:0F713BC9-1452-41D1-A390-269A5FD8816A@.microsoft.com...
> when i try new SQL sever registration it says does not exist or acces
> denied
Can you connect to the other Server using other means? Can you ping the
other server?
Can you connect to the other server using Query Analyzer?
Is the MSSQLServer service running on the other server?
Just a few things to check first.
Rick Sawtell
MCT, MCSD, MCDBA|||im not trying to JOIN A SEVER im trying to MAKE sever
"Rick Sawtell" wrote:

> "Robert" <Robert@.discussions.microsoft.com> wrote in message
> news:0F713BC9-1452-41D1-A390-269A5FD8816A@.microsoft.com...
> Can you connect to the other Server using other means? Can you ping the
> other server?
> Can you connect to the other server using Query Analyzer?
> Is the MSSQLServer service running on the other server?
> Just a few things to check first.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
>|||When you use Enterprise Manager to register a server, that's
intended for connecting to an existing SQL Server instance.
If you want to create another new instance, you need to
install SQL Server from the installation CD.
-Sue
On Thu, 27 Jan 2005 11:37:01 -0800, Robert
<Robert@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>im not trying to JOIN A SEVER im trying to MAKE sever
>"Rick Sawtell" wrote:
>