Access denied

Hello,
I have been running SQLSvr 2000 (sp3) on Win2k+SP3.
I upgraded Windows 2000 with Win2k SP4 yesterday, and
reinstalled SQLSvr 2000 and SQL Svr SP3. After that, I
cannot start up the SQl Svr from my following program ( I
can manually start the SQlSvr from the SQLSvr manager).
mySQLSvr = SQLDMO.SQLServer
mySQLSvr.start ibConnect mszSvrName
I got an unknown error : -2147024891. I looked into this
error, it is
"[9/4/2003 3:03:10 PM] Returned err numer:-2147024891; err
desc:[SQL-DMO]Service Control Error: Access is denied."\
Would you like to tell me if Win 2k Sp4 has changed any
security stuff?
I really appreciate your help.
Many thanks
MarkHeard from our sysadmin that Win2k SP4 has problems on servers. Did not go
into detail, but he said for the workstations it's fine, but not for server
.....
"Mark" <luyuan_l@.telus.net> wrote in message
news:228c01c3732b$8739dc90$a501280a@.phx.gbl...
> Hello,
> I have been running SQLSvr 2000 (sp3) on Win2k+SP3.
> I upgraded Windows 2000 with Win2k SP4 yesterday, and
> reinstalled SQLSvr 2000 and SQL Svr SP3. After that, I
> cannot start up the SQl Svr from my following program ( I
> can manually start the SQlSvr from the SQLSvr manager).
> mySQLSvr = SQLDMO.SQLServer
> mySQLSvr.start ibConnect mszSvrName
> I got an unknown error : -2147024891. I looked into this
> error, it is
> "[9/4/2003 3:03:10 PM] Returned err numer:-2147024891; err
> desc:[SQL-DMO]Service Control Error: Access is denied."\
> Would you like to tell me if Win 2k Sp4 has changed any
> security stuff?
> I really appreciate your help.
> Many thanks
> Mark
>

Access 2003 to SQL Server 2005 Express no hyperlink

I upgraded an Access 2003 database to SQL Server 2005 Express with the upsize wizard- worked great! Have a field that needs to be a hyperlink data type. There is no datatype in SQL that is hyperlink. Even if it were a text field, possibly inserting a hyperlink would work, but the insert hyplink in Access is unavailable, because the datasource is sql, maybe. I have a command button that ties to this function which won't work, obviously since it is not available. I need this field, it points to a file containing data that is being imported into the database. Huge piece of the database functionality. Making it easy for the user to find the file and using the vba to convert the data.

Saw the option of jump to url, but I don't think that will work? couldn't find the exact syntax either.

Any ideas would be greatly appreciated!

Robin

I guess you are talking about two different things, the database engine upgrade and the reporting upgrade. Which one is making your problems ? If I am wrong, please let me know, that we can help you fast with your problem.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Sorry, I didn't see it as two different things...didn't even realize I was talking about a reporting upgrade? I have a sql server 2005 backend - so the fields are in that database....I refer to all of those fields in the Access 2003 database and I need one of those fields to be a hyperlink field....it was a hyperlink field when the data was in Access and I need it to be a hyperlink field now. There must be a way to keep that consistency,right?

Thanks for your input....sorry if it was misinterpreted about what was going on.

Robin

|||

There is no SQL Server equivalent to the Hyperlink field in Access, you will need to code a solution for following hyperlinks directly in your application. If your application is still in Access, you should explore the FollowHyperlink function. If you are moving to a Windows Forms application, you should check out the DataGridView, specifically the DataGridViewLinkColumns Namespace and the DataGridView.CellContentClick event to handle following the hyperlink.

As far as storing the hyperlink, I would suggest just using an nvarchar.

Mike

|||

Mike, thanks for responding to my dilemma. I am going to keep the front end in Access so I'll check out the followhyperlink function. It was great with the insert hyperlink dialog box, but we'll have to work around that.

I'd also like to add, I've looked at a number of threads on this site and appreciate your input - you are to the point, explain things very well and make sure the person you are addressing gets the point. I was hoping you would respond to my issue because I knew you would answer it correctly.

Thanks again!

Take care

Robin

|||

Mike, sorry to pick this up again, but is there any way for a user to easily find a file to insert into a field that is from a sql server be. I want them to be able to point to a file and have it copied into a field, insert hyperlink did it well. The field tells the database where to find a file\which file that is going to be imported into the database. Perhaps there is a more direct way in sql using the access front end?

Thanks!

Robin

about Processor License

Hi,
we have one Windows 2000 Server which just upgraded from 2 processors
to 4 processors, my question is: if I buy two more licenses for SQL
Server, how can I upgrade? do I need reinstall sql server, or I just
don't need do nothing?
Thanks.You shouldn't have to do anything to SQL Server to take advantage of the
additional processors. You can add the licenses in the SQL 2000 Licensing
Setup control panel, but I'm not sure that this anything more than document
your licenses.
Mike Kruchten
"Woody" <woodygu@.yahoo.com> wrote in message
news:2313e36d.0408120808.1f082209@.posting.google.com...
> Hi,
> we have one Windows 2000 Server which just upgraded from 2 processors
> to 4 processors, my question is: if I buy two more licenses for SQL
> Server, how can I upgrade? do I need reinstall sql server, or I just
> don't need do nothing?
> Thanks.

about Processor License

Hi,
we have one Windows 2000 Server which just upgraded from 2 processors
to 4 processors, my question is: if I buy two more licenses for SQL
Server, how can I upgrade? do I need reinstall sql server, or I just
don't need do nothing?
Thanks.
You shouldn't have to do anything to SQL Server to take advantage of the
additional processors. You can add the licenses in the SQL 2000 Licensing
Setup control panel, but I'm not sure that this anything more than document
your licenses.
Mike Kruchten
"Woody" <woodygu@.yahoo.com> wrote in message
news:2313e36d.0408120808.1f082209@.posting.google.c om...
> Hi,
> we have one Windows 2000 Server which just upgraded from 2 processors
> to 4 processors, my question is: if I buy two more licenses for SQL
> Server, how can I upgrade? do I need reinstall sql server, or I just
> don't need do nothing?
> Thanks.

about Processor License

Hi,
we have one Windows 2000 Server which just upgraded from 2 processors
to 4 processors, my question is: if I buy two more licenses for SQL
Server, how can I upgrade? do I need reinstall sql server, or I just
don't need do nothing?
Thanks.You shouldn't have to do anything to SQL Server to take advantage of the
additional processors. You can add the licenses in the SQL 2000 Licensing
Setup control panel, but I'm not sure that this anything more than document
your licenses.
Mike Kruchten
"Woody" <woodygu@.yahoo.com> wrote in message
news:2313e36d.0408120808.1f082209@.posting.google.com...
> Hi,
> we have one Windows 2000 Server which just upgraded from 2 processors
> to 4 processors, my question is: if I buy two more licenses for SQL
> Server, how can I upgrade? do I need reinstall sql server, or I just
> don't need do nothing?
> Thanks.