Error encountered during registration of server in sql server 6.5

Pls help.
We still have sql server 6.5. I was trying to register
server with the same version however an error was
encountered. The error is "Unable to connect: Sql server
is unavailable or does not exists. OS error 1326 -
ConnectionOpen(CreateFile())". Does anyone know how to
resolve this? Thanks =)HI,
Create a Alias server using SQL Client configuration utility and register
the server in enterprise manager using that Alias name created.
(Check the MSSQL server service is up)
Thanks
Hari
MCDBA
"cherry" <anonymous@.discussions.microsoft.com> wrote in message
news:1678a01c41709$aacc5980$a101280a@.phx
.gbl...
> Pls help.
> We still have sql server 6.5. I was trying to register
> server with the same version however an error was
> encountered. The error is "Unable to connect: Sql server
> is unavailable or does not exists. OS error 1326 -
> ConnectionOpen(CreateFile())". Does anyone know how to
> resolve this? Thanks =)|||how can i create an alias server using SQL Client
configuration utility. The tab available in this utility
are db library, net library and advanced.

>--Original Message--
>HI,
>Create a Alias server using SQL Client configuration
utility and register
>the server in enterprise manager using that Alias name
created.
>(Check the MSSQL server service is up)
>Thanks
>Hari
>MCDBA
>
>"cherry" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1678a01c41709$aacc5980$a101280a@.phx
.gbl...
>
>.
>|||Check the advanced tab.
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"cherry" <anonymous@.discussions.microsoft.com> wrote in message
news:161ed01c4170d$e1469710$a301280a@.phx
.gbl...
> how can i create an alias server using SQL Client
> configuration utility. The tab available in this utility
> are db library, net library and advanced.
>
> utility and register
> created.
> message

Error Deploying Report

I'm getting a strange error when deploying a report:
Server was unable to process request. --> Could not find file "C:
\WINDOWS\TEMP\7qifavw2.dll".
The strange part is that the dll file name changes each time i try to
deploy. The deploy function was working when I left last night, and
not working first thing this morning. Any idea what's happening here?ugh
I rebooted and it started working again. Strange thing though. I was
trying this from my pc, as well as from the server itself, and got the
same error. Rebooting my pc did not help, but rebooting the server
did. Oh well, now if I had only rebooted a couple hours sooner :-(|||The reason the name of the DLL changes is that this is the compiled result
of some ASP.NET code. I'm surprised that the location is C:\WINDOWS\TEMP --
are you sure? -- but I would expect that location to be different on
different machines and in different OS.
This can happen when something on a site changes and ASP.NET tries to
refresh its compiled code but something interferes with the whole thing
happening correctly. Sometimes it may be a user session that is open and
"pointed" to a particular page on the site.
What I usually do is stop the application in question and clear out *all*
the compiled code for it, so that when the application starts up again
ASP.NET recompiles everything from scratch. I can't be more specific than
that because I really don't know why you would be getting this when
"deploying a report". Which action, exactly, invokes the error on your PC?
>L<
<c-eric.geil@.mci.com> wrote in message
news:1176998968.836336.124600@.e65g2000hsc.googlegroups.com...
> I'm getting a strange error when deploying a report:
> Server was unable to process request. --> Could not find file "C:
> \WINDOWS\TEMP\7qifavw2.dll".
> The strange part is that the dll file name changes each time i try to
> deploy. The deploy function was working when I left last night, and
> not working first thing this morning. Any idea what's happening here?
>

Error Creating Role on Cube

I am trying to create a role on a dimension and when I
click on the Test Role button, I get the following
error.
"Unable to process one or more commands. User-generated
error - the dimension "All Regions" has no valid member.
For more information, see your administrator."
Below is the mdx that I have entered on the All Regions
dimension of my role.
FILTER(
{[All Regions].[Region Name].Members},
(((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNAME,"\")+1 ,128)),
[SFAccessre])=1)
AND ((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNAME,"\")
+1,128)),[Cube Typere])=1)
AND ((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNAME,"\")
+1,128)),[Dimension Typere])=1)))
I am able to browse the data of the All Regions
dimension. The dimensions SFAccessre, Cube Typere and
Dimension Typere are all in a Users Region dimension.
I use a similar MDX statement for security on another
dimension in my cube.
TIA
Hi,
When you execute the Test Role button, it takes in the Logged in User and
tries to apply the Security MDX on this. (Bascially the UserName function
would return the Logged in User's Information.)
Please check if the Logged in user has got corresponding records in the All
Regions Dimension.
Thanks,
Sanka
"Craig" wrote:

> I am trying to create a role on a dimension and when I
> click on the Test Role button, I get the following
> error.
> "Unable to process one or more commands. User-generated
> error - the dimension "All Regions" has no valid member.
> For more information, see your administrator."
> Below is the mdx that I have entered on the All Regions
> dimension of my role.
> FILTER(
> {[All Regions].[Region Name].Members},
> (((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNAME,"\")+1 ,128)),
> [SFAccessre])=1)
> AND ((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNAME,"\")
> +1,128)),[Cube Typere])=1)
> AND ((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNAME,"\")
> +1,128)),[Dimension Typere])=1)))
> I am able to browse the data of the All Regions
> dimension. The dimensions SFAccessre, Cube Typere and
> Dimension Typere are all in a Users Region dimension.
> I use a similar MDX statement for security on another
> dimension in my cube.
> TIA
>

Error Creating Role on Cube

I am trying to create a role on a dimension and when I
click on the Test Role button, I get the following
error.
"Unable to process one or more commands. User-generated
error - the dimension "All Regions" has no valid member.
For more information, see your administrator."
Below is the mdx that I have entered on the All Regions
dimension of my role.
FILTER(
{[All Regions].[Region Name].Members},
(((STRTOTUPLE(MID(USERNAME,INSTR(1,USERN
AME,"\")+1,128)),
[SFAccessre])=1)
AND ((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNA
ME,"\")
+1,128)),[Cube Typere])=1)
AND ((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNA
ME,"\")
+1,128)),[Dimension Typere])=1)))
I am able to browse the data of the All Regions
dimension. The dimensions SFAccessre, Cube Typere and
Dimension Typere are all in a Users Region dimension.
I use a similar MDX statement for security on another
dimension in my cube.
TIAHi,
When you execute the Test Role button, it takes in the Logged in User and
tries to apply the Security MDX on this. (Bascially the UserName function
would return the Logged in User's Information.)
Please check if the Logged in user has got corresponding records in the All
Regions Dimension.
Thanks,
Sanka
"Craig" wrote:

> I am trying to create a role on a dimension and when I
> click on the Test Role button, I get the following
> error.
> "Unable to process one or more commands. User-generated
> error - the dimension "All Regions" has no valid member.
> For more information, see your administrator."
> Below is the mdx that I have entered on the All Regions
> dimension of my role.
> FILTER(
> {[All Regions].[Region Name].Members},
> (((STRTOTUPLE(MID(USERNAME,INSTR(1,USERN
AME,"\")+1,128)),
> [SFAccessre])=1)
> AND ((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNA
ME,"\")
> +1,128)),[Cube Typere])=1)
> AND ((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNA
ME,"\")
> +1,128)),[Dimension Typere])=1)))
> I am able to browse the data of the All Regions
> dimension. The dimensions SFAccessre, Cube Typere and
> Dimension Typere are all in a Users Region dimension.
> I use a similar MDX statement for security on another
> dimension in my cube.
> TIA
>

error connecting to sql 2k from an app

Hi,
I rec'd this error.
open dbtables error: General error: Unable to write to file buffer dbtest.
when I connect to a sql 2k db from an test app.
Any ideas?
thanksCan you show the code that is trying to connect? This doesn't look like a
SQL Server error as far as I can tell.
"mecn" <mecn2002@.yahoo.com> wrote in message
news:OMglZPIPGHA.1676@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I rec'd this error.
> open dbtables error: General error: Unable to write to file buffer dbtest.
> when I connect to a sql 2k db from an test app.
> Any ideas?
> thanks
>|||I don't really have the source code.
I think the same as you--windows' problem.
Everytime the app runs it generated a temp file > 2GB.
I have no idea why the temp file gets generated when the app sends a query
statment.
That is the problem
Thanks,
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uwrjxcIPGHA.344@.TK2MSFTNGP11.phx.gbl...
> Can you show the code that is trying to connect? This doesn't look like a
> SQL Server error as far as I can tell.
>
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:OMglZPIPGHA.1676@.TK2MSFTNGP09.phx.gbl...
>

Error connecting to Report Manager

System.Net.WebException: Unable to connect to the remote server -->
System.Net.Sockets.SocketException: No connection could be made because the
target machine actively refused it 127.0.0.1:443
Can someone help me with that error?
ThanksThats a bit unusual. Try this post
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=552017&SiteID=1
Cheers
Shai
On Nov 19, 11:46 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
> System.Net.WebException: Unable to connect to the remote server -->
> System.Net.Sockets.SocketException: No connection could be made because the
> target machine actively refused it 127.0.0.1:443
> Can someone help me with that error?
> Thanks

Error browsing cube data

I was trying to browse a cube that i had created. It however tells me its unable to browse cube data. Unspecified error. When i am creating the dimension i cannot also preview the data. How can i have thes resolved?

Are you a new user of Analysis Services. Did you deployed your cube to Analysis Server? What exactly the error you getting?

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

error attaching single db .mdf file

Hi,
The dev deleted some of the ldf files mistakenly and are unable to attach the mdf file.
How can i re-create the db with the existing mdf file and a new ldf file. Can someone suggest.
Thanks,
Arzan
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
Andrew J. Kelly SQL MVP
"Arzan" <Arzan@.discussions.microsoft.com> wrote in message
news:8A81A4E5-F699-4552-A0C0-8310527A7EA5@.microsoft.com...
> Hi,
> The dev deleted some of the ldf files mistakenly and are unable to attach
the mdf file.
> How can i re-create the db with the existing mdf file and a new ldf file.
Can someone suggest.
> Thanks,
> Arzan
|||Hi,
Try using the procedure "sp_attach_single_file_db" to attach the database
with specifying the MDF file only.
EXEC sp_attach_single_file_db 'dbname', 'c:\mssql\data\dbname.mdf'
THis will create a new database with exiting mdf and new ldf file.
This command will fail in below scenarios:-
1. If the database is not detached using sp_detach_db
2. If you have multiple LDF files in your old database.
If your sp_attach_single_file_db command fails then probaly you have to
restore the database from good backup available.
Thanks
Hari
MCDBA
"Arzan" <Arzan@.discussions.microsoft.com> wrote in message
news:8A81A4E5-F699-4552-A0C0-8310527A7EA5@.microsoft.com...
> Hi,
> The dev deleted some of the ldf files mistakenly and are unable to attach
the mdf file.
> How can i re-create the db with the existing mdf file and a new ldf file.
Can someone suggest.
> Thanks,
> Arzan
|||Thanks Hari, the problem has been resolved.
"Hari Prasad" wrote:

> Hi,
> Try using the procedure "sp_attach_single_file_db" to attach the database
> with specifying the MDF file only.
> EXEC sp_attach_single_file_db 'dbname', 'c:\mssql\data\dbname.mdf'
> THis will create a new database with exiting mdf and new ldf file.
> This command will fail in below scenarios:-
> 1. If the database is not detached using sp_detach_db
> 2. If you have multiple LDF files in your old database.
> If your sp_attach_single_file_db command fails then probaly you have to
> restore the database from good backup available.
> Thanks
> Hari
> MCDBA
>
> "Arzan" <Arzan@.discussions.microsoft.com> wrote in message
> news:8A81A4E5-F699-4552-A0C0-8310527A7EA5@.microsoft.com...
> the mdf file.
> Can someone suggest.
>
>

error attaching single db .mdf file

Hi,
The dev deleted some of the ldf files mistakenly and are unable to attach th
e mdf file.
How can i re-create the db with the existing mdf file and a new ldf file. Ca
n someone suggest.
Thanks,
Arzanhttp://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
Andrew J. Kelly SQL MVP
"Arzan" <Arzan@.discussions.microsoft.com> wrote in message
news:8A81A4E5-F699-4552-A0C0-8310527A7EA5@.microsoft.com...
> Hi,
> The dev deleted some of the ldf files mistakenly and are unable to attach
the mdf file.
> How can i re-create the db with the existing mdf file and a new ldf file.
Can someone suggest.
> Thanks,
> Arzan|||Hi,
Try using the procedure "sp_attach_single_file_db" to attach the database
with specifying the MDF file only.
EXEC sp_attach_single_file_db 'dbname', 'c:\mssql\data\dbname.mdf'
THis will create a new database with exiting mdf and new ldf file.
This command will fail in below scenarios:-
1. If the database is not detached using sp_detach_db
2. If you have multiple LDF files in your old database.
If your sp_attach_single_file_db command fails then probaly you have to
restore the database from good backup available.
Thanks
Hari
MCDBA
"Arzan" <Arzan@.discussions.microsoft.com> wrote in message
news:8A81A4E5-F699-4552-A0C0-8310527A7EA5@.microsoft.com...
> Hi,
> The dev deleted some of the ldf files mistakenly and are unable to attach
the mdf file.
> How can i re-create the db with the existing mdf file and a new ldf file.
Can someone suggest.
> Thanks,
> Arzan|||Thanks Hari, the problem has been resolved.
"Hari Prasad" wrote:

> Hi,
> Try using the procedure "sp_attach_single_file_db" to attach the database
> with specifying the MDF file only.
> EXEC sp_attach_single_file_db 'dbname', 'c:\mssql\data\dbname.mdf'
> THis will create a new database with exiting mdf and new ldf file.
> This command will fail in below scenarios:-
> 1. If the database is not detached using sp_detach_db
> 2. If you have multiple LDF files in your old database.
> If your sp_attach_single_file_db command fails then probaly you have to
> restore the database from good backup available.
> Thanks
> Hari
> MCDBA
>
> "Arzan" <Arzan@.discussions.microsoft.com> wrote in message
> news:8A81A4E5-F699-4552-A0C0-8310527A7EA5@.microsoft.com...
> the mdf file.
> Can someone suggest.
>
>

error attaching single db .mdf file

Hi,
The dev deleted some of the ldf files mistakenly and are unable to attach the mdf file.
How can i re-create the db with the existing mdf file and a new ldf file. Can someone suggest.
Thanks,
Arzanhttp://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
--
Andrew J. Kelly SQL MVP
"Arzan" <Arzan@.discussions.microsoft.com> wrote in message
news:8A81A4E5-F699-4552-A0C0-8310527A7EA5@.microsoft.com...
> Hi,
> The dev deleted some of the ldf files mistakenly and are unable to attach
the mdf file.
> How can i re-create the db with the existing mdf file and a new ldf file.
Can someone suggest.
> Thanks,
> Arzan|||Hi,
Try using the procedure "sp_attach_single_file_db" to attach the database
with specifying the MDF file only.
EXEC sp_attach_single_file_db 'dbname', 'c:\mssql\data\dbname.mdf'
THis will create a new database with exiting mdf and new ldf file.
This command will fail in below scenarios:-
1. If the database is not detached using sp_detach_db
2. If you have multiple LDF files in your old database.
If your sp_attach_single_file_db command fails then probaly you have to
restore the database from good backup available.
Thanks
Hari
MCDBA
"Arzan" <Arzan@.discussions.microsoft.com> wrote in message
news:8A81A4E5-F699-4552-A0C0-8310527A7EA5@.microsoft.com...
> Hi,
> The dev deleted some of the ldf files mistakenly and are unable to attach
the mdf file.
> How can i re-create the db with the existing mdf file and a new ldf file.
Can someone suggest.
> Thanks,
> Arzan

Error adding an Account to a Profile for 'Database Mail'

Configuring...
- Create new account 'SQL Agent SMTP Account' for SMTP server {exchange
server}(Error)
Messages
â?¢ Unable to create new account SQL Agent SMTP Account for SMTP server
Microsoft.SqlServer.Management.SqlManagerUI.SQLiMailServer.
--
ADDITIONAL INFORMATION:
Create failed for MailAccount 'SQL Agent SMTP Account'.
(Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+MailAccount&LinkId=20476
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
Cannot insert the value NULL into column 'servername', table
'msdb.dbo.sysmail_server'; column does not allow nulls. INSERT fails.
The statement has been terminated. (Microsoft SQL Server, Error: 515) {this
was filled in. Don't kow why it is saying it was NULL}
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=515&LinkId=20476
- Update profile 'Mail Profile For SQL Server Agent' (Success)
- Add account 'SQL Agent SMTP Account' to profile 'Mail Profile For SQL
Server Agent' with priority '1' (Error)
Messages
â?¢ Unable to add account SQL Agent SMTP Account to profile Mail Profile For
SQL Server Agent.
--
ADDITIONAL INFORMATION:
Add MailAccount to MailProfile failed for MailProfile 'Mail Profile For SQL
Server Agent'. (Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Add+MailAccount+to+MailProfile+MailProfile&LinkId=20476
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
account name is not valid (Microsoft SQL Server, Error: 14607)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14607&LinkId=20476Wild guess: What does below return:
SELECT @.@.SERVERNAME
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Buehler" <Buehler@.discussions.microsoft.com> wrote in message
news:39B595AE-DC22-4D4C-8921-EB67AAFD5B72@.microsoft.com...
> Configuring...
> - Create new account 'SQL Agent SMTP Account' for SMTP server {exchange
> server}(Error)
> Messages
> â?¢ Unable to create new account SQL Agent SMTP Account for SMTP server
> Microsoft.SqlServer.Management.SqlManagerUI.SQLiMailServer.
> --
> ADDITIONAL INFORMATION:
> Create failed for MailAccount 'SQL Agent SMTP Account'.
> (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+MailAccount&LinkId=20476
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Cannot insert the value NULL into column 'servername', table
> 'msdb.dbo.sysmail_server'; column does not allow nulls. INSERT fails.
> The statement has been terminated. (Microsoft SQL Server, Error: 515) {this
> was filled in. Don't kow why it is saying it was NULL}
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=515&LinkId=20476
>
> - Update profile 'Mail Profile For SQL Server Agent' (Success)
> - Add account 'SQL Agent SMTP Account' to profile 'Mail Profile For SQL
> Server Agent' with priority '1' (Error)
> Messages
> â?¢ Unable to add account SQL Agent SMTP Account to profile Mail Profile For
> SQL Server Agent.
> --
> ADDITIONAL INFORMATION:
> Add MailAccount to MailProfile failed for MailProfile 'Mail Profile For SQL
> Server Agent'. (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Add+MailAccount+to+MailProfile+MailProfile&LinkId=20476
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> account name is not valid (Microsoft SQL Server, Error: 14607)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14607&LinkId=20476
>|||found solution. There is a 'bug' in the wizard. used
dbo.sysmail_add_account_sp to add account.

Error adding an Account to a Profile for 'Database Mail'

Configuring...
- Create new account 'SQL Agent SMTP Account' for SMTP server {exchange
server}(Error)
Messages
? Unable to create new account SQL Agent SMTP Account for SMTP server
Microsoft.SqlServer.Management.SqlManagerUI.SQLiMailServer.
ADDITIONAL INFORMATION:
Create failed for MailAccount 'SQL Agent SMTP Account'.
(Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?Prod...nt&LinkId=20476
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Cannot insert the value NULL into column 'servername', table
'msdb.dbo.sysmail_server'; column does not allow nulls. INSERT fails.
The statement has been terminated. (Microsoft SQL Server, Error: 515) {
this
was filled in. Don't kow why it is saying it was NULL}
For help, click:
http://go.microsoft.com/fwlink?Prod...15&LinkId=20476
- Update profile 'Mail Profile For SQL Server Agent' (Success)
- Add account 'SQL Agent SMTP Account' to profile 'Mail Profile For SQL
Server Agent' with priority '1' (Error)
Messages
? Unable to add account SQL Agent SMTP Account to profile Mail Profile For
SQL Server Agent.
ADDITIONAL INFORMATION:
Add MailAccount to MailProfile failed for MailProfile 'Mail Profile For SQL
Server Agent'. (Microsoft.SqlServer.Smo)
For help, click:
http://go.microsoft.com/fwlink?Prod...le&LinkId=20476
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
account name is not valid (Microsoft SQL Server, Error: 14607)
For help, click:
http://go.microsoft.com/fwlink?Prod...07&LinkId=20476Wild guess: What does below return:
SELECT @.@.SERVERNAME
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Buehler" <Buehler@.discussions.microsoft.com> wrote in message
news:39B595AE-DC22-4D4C-8921-EB67AAFD5B72@.microsoft.com...
> Configuring...
> - Create new account 'SQL Agent SMTP Account' for SMTP server {exchan
ge
> server}(Error)
> Messages
> ? Unable to create new account SQL Agent SMTP Account for SMTP server
> Microsoft.SqlServer.Management.SqlManagerUI.SQLiMailServer.
> --
> ADDITIONAL INFORMATION:
> Create failed for MailAccount 'SQL Agent SMTP Account'.
> (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...nt&LinkId=20476
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Cannot insert the value NULL into column 'servername', table
> 'msdb.dbo.sysmail_server'; column does not allow nulls. INSERT fails.
> The statement has been terminated. (Microsoft SQL Server, Error: 515) 
3;this
> was filled in. Don't kow why it is saying it was NULL}
> For help, click:
> http://go.microsoft.com/fwlink?Prod...15&LinkId=20476
>
> - Update profile 'Mail Profile For SQL Server Agent' (Success)
> - Add account 'SQL Agent SMTP Account' to profile 'Mail Profile For SQL
> Server Agent' with priority '1' (Error)
> Messages
> ? Unable to add account SQL Agent SMTP Account to profile Mail Profile F
or
> SQL Server Agent.
> --
> ADDITIONAL INFORMATION:
> Add MailAccount to MailProfile failed for MailProfile 'Mail Profile For SQ
L
> Server Agent'. (Microsoft.SqlServer.Smo)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...le&LinkId=20476
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> account name is not valid (Microsoft SQL Server, Error: 14607)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...07&LinkId=20476
>|||found solution. There is a 'bug' in the wizard. used
dbo.sysmail_add_account_sp to add account.