Cant Schedule Backup

Hello All,

I using sqlserver 6.5 and I am trying to schedule a backup and I get this error message, how can I resolve this? This is the error message I am getting:

"The SQLExecutive service is not currently running on this server. This prevents task backup-master from being run."

Thanks in Advance.How about starting SQLExecutive service? I'm sure it'll help a lot!|||how is that done. There doesn't seem to be a start up for that service or choice to start it up. The only check box is a startup autumatically when server startup.

can't resolve sortingconflict for equel to

Hi,
I'm trying create a simple select statment with a join in the tempdb.
However i'm getting errors which says that it can't resolve a
sortingconflict in the equal to line.
Here's my select statement, maybe someone can see the problem.
use tempdb
select p.name, ad.adress
from test.dbo.persons p
inner join adresses ad
on p.id = ad.id
----
This mailbox protected from junk email by MailFrontier Desktop
from MailFrontier, Inc. http://info.mailfrontier.comHi
The TempDb collation is different to the DB's one.
Look at the index keyword "collations, mixed collation environments" in BOL.
Has some great information there.
Regards
Mike
"Jason" wrote:

> Hi,
> I'm trying create a simple select statment with a join in the tempdb.
> However i'm getting errors which says that it can't resolve a
> sortingconflict in the equal to line.
> Here's my select statement, maybe someone can see the problem.
> use tempdb
> select p.name, ad.adress
> from test.dbo.persons p
> inner join adresses ad
> on p.id = ad.id
>
> --
>
> ----
> This mailbox protected from junk email by MailFrontier Desktop
> from MailFrontier, Inc. http://info.mailfrontier.com
>
>

Can't login into SQL Server Database

Hey
I get the following error when trying to connect to my named instance Sql
Server running locally on my laptop. Does anyone know how to resolve this
I get the following error : Login failed for user:acw
Here is my code:
SqlConnection sConn = new SqlConnection(server=ACLAPTOP\ACSQLSERVE
R;User
id=acw; Password=;Database=BookSpot);
Thanks,
AlAl
Open QA and try to log in with the user. Do you get the same error?
"Al Wilkerson" <ac527@.comcast.net> wrote in message
news:7aCdnUdO-Ipm37zfRVn-gA@.comcast.com...
> Hey
> I get the following error when trying to connect to my named instance Sql
> Server running locally on my laptop. Does anyone know how to resolve this
> I get the following error : Login failed for user:acw
> Here is my code:
> SqlConnection sConn = new SqlConnection(server=ACLAPTOP\ACSQLSERVE
R;User
> id=acw; Password=;Database=BookSpot);
>
> Thanks,
> --
> Al
>|||I assume this is C# code. Did you give this user a blank password?
Double-check the password for this user and the rights/roles granted to this
user in EM. I assume your connection string is properly quoted (or it
wouldn't even compile for you). Finally, are you using Integrated Security
or SQL Server Authentication?
Thx
Mike C.
"Al Wilkerson" <ac527@.comcast.net> wrote in message
news:7aCdnUdO-Ipm37zfRVn-gA@.comcast.com...
> Hey
> I get the following error when trying to connect to my named instance Sql
> Server running locally on my laptop. Does anyone know how to resolve this
> I get the following error : Login failed for user:acw
> Here is my code:
> SqlConnection sConn = new SqlConnection(server=ACLAPTOP\ACSQLSERVE
R;User
> id=acw; Password=;Database=BookSpot);
>
> Thanks,
> --
> Al
>