Showing posts with label basic. Show all posts
Showing posts with label basic. Show all posts

Monday, March 19, 2012

doubt in crystal report(help needed Urgently)

hai

I have one doubt in crystal report.I am using crystal report 7 version.I added a databse to report and i connected that report with visual basic and my report is working.Except that i cant refresh my report at runtime and so it displays the same values repeatedly.

I cant use crystal report 8 or 9 or 10.

Help needed urgently

Bye
Ramyafrom file menu of crystal report , uncheck the option of 'Save Data with Report', then save the file and try .|||hai

i have one doubt i am using crystal report from visual basic and not directly from crstal report.

That is i added report at project itself and so where to change that option

Bye
Ramya

Doubt about SQL Server

I need an application to obtain the databases names from my SQL
Server, using Visual Basic 6.0.
Can somebody hel me?(aguzmanc@.gmail.com) writes:

Quote:

Originally Posted by

I need an application to obtain the databases names from my SQL
Server, using Visual Basic 6.0.
Can somebody hel me?


SELECT name FROM master..sysdatabases -- SQL 2000 or earlier
SELECT name FROM sys.databases -- SQL 2005.

Or what is you want help with?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Sunday, February 26, 2012

Domain to Workgroup connections

Hello everyone,
Here's the setup:
I'm trying to get an basic ADO application on my
workstation (Win2K Pro, on a domain), to talk to SQL 2000
on a server (Win2K Server, on a workgroup all by itself).
The SQL server is using Windows Authentication.
Any ideas how I can get this to work? Our application is
capable of 'impersonating' other users, but when I get it
to impersonate MYSERVER\Administrator it just says the
user id / password is invalid.
Can't get query analyser to talk to the server at all.
Thanks,
Mark.
The only way to make this work is to have identical usernames and password
on both machines. In other words, the Administrator account on the Worgroup
machine has to have the same password on the MYSERVER domain. This should
allow passthrough authentication to work.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Domain to workgroup connections

Hello everyone,
Here's the setup:
I'm trying to get a basic ADO application on my
workstation (Win2K Pro, on a domain), to talk to SQL 2000
on a server (Win2K Server, on a workgroup all by itself).
The SQL server is using Windows Authentication.
Any ideas how I can get this to work? Our application is
capable of 'impersonating' other users, but when I get it
to impersonate MYSERVER\Administrator it just says the
user id / password is invalid.
Can't get query analyser to talk to the server at all.
Thanks,
Mark.This may be a Windows authenication issue alone. If you set up a local accou
nt on the workstation, then set up the same local account with the same pass
word on the server, then run your app with the local account. This setup wil
l allow your workstatino to
talk to the server (I'd try to get query analyser to work under this configu
ration first). This is a feature of Windows to allow standalone computers to
authenicate users.
Don't know how your app implements 'impersonating'. So 'impersonating' the l
ocal account under your app may or may not work.
-- Mark Hutchings wrote: --
Hello everyone,
Here's the setup:
I'm trying to get a basic ADO application on my
workstation (Win2K Pro, on a domain), to talk to SQL 2000
on a server (Win2K Server, on a workgroup all by itself).
The SQL server is using Windows Authentication.
Any ideas how I can get this to work? Our application is
capable of 'impersonating' other users, but when I get it
to impersonate MYSERVER\Administrator it just says the
user id / password is invalid.
Can't get query analyser to talk to the server at all.
Thanks,
Mark.

Sunday, February 19, 2012

Domain administrator password change

Hi folks. Sorry if this one's a bit basic, but I'm a SQL 2000 novice.
I've just taken over responsability for some servers and I need to
change the domain administrator password.
I was wondering if changing this will have any adverse affects on SQL.
The SQL server is a domain controller. Only the SQLSERVERAGENT service
uses the administrator account.
Will I have any problems "internal" to SQL after the password is changed?
Thanks for any tips.

Hi,
After the change you need to change the password for SQLServer Agent with
new password.
How to change the startup account:-
1. Control Panel - Admin tools -- Services
2. Double click above the SQLSERVERAGENT service
3. In the Log on tab, change the OS user name and enter the password, Click
ok and restart the service.
Thanks
Hari
SQL Server MVP
"David Pounds" <david.pounds@.hohohohohohahahahahah.bum> wrote in message
news:Oaib5H5VFHA.132@.TK2MSFTNGP14.phx.gbl...
> Hi folks. Sorry if this one's a bit basic, but I'm a SQL 2000 novice.
> I've just taken over responsability for some servers and I need to change
> the domain administrator password.
> I was wondering if changing this will have any adverse affects on SQL.
> The SQL server is a domain controller. Only the SQLSERVERAGENT service
> uses the administrator account.
> Will I have any problems "internal" to SQL after the password is changed?
> Thanks for any tips.
>
|||Nice one - thought that was it but always good to check.
Thank you.
Hari Prasad wrote:
> Hi,
> After the change you need to change the password for SQLServer Agent with
> new password.
> How to change the startup account:-
> 1. Control Panel - Admin tools -- Services
> 2. Double click above the SQLSERVERAGENT service
> 3. In the Log on tab, change the OS user name and enter the password, Click
> ok and restart the service.
> Thanks
> Hari
> SQL Server MVP
> "David Pounds" <david.pounds@.hohohohohohahahahahah.bum> wrote in message
> news:Oaib5H5VFHA.132@.TK2MSFTNGP14.phx.gbl...
>
>

Domain administrator password change

Hi folks. Sorry if this one's a bit basic, but I'm a SQL 2000 novice.
I've just taken over responsability for some servers and I need to
change the domain administrator password.
I was wondering if changing this will have any adverse affects on SQL.
The SQL server is a domain controller. Only the SQLSERVERAGENT service
uses the administrator account.
Will I have any problems "internal" to SQL after the password is changed?
Thanks for any tips.
:)Hi,
After the change you need to change the password for SQLServer Agent with
new password.
How to change the startup account:-
1. Control Panel - Admin tools -- Services
2. Double click above the SQLSERVERAGENT service
3. In the Log on tab, change the OS user name and enter the password, Click
ok and restart the service.
Thanks
Hari
SQL Server MVP
"David Pounds" <david.pounds@.hohohohohohahahahahah.bum> wrote in message
news:Oaib5H5VFHA.132@.TK2MSFTNGP14.phx.gbl...
> Hi folks. Sorry if this one's a bit basic, but I'm a SQL 2000 novice.
> I've just taken over responsability for some servers and I need to change
> the domain administrator password.
> I was wondering if changing this will have any adverse affects on SQL.
> The SQL server is a domain controller. Only the SQLSERVERAGENT service
> uses the administrator account.
> Will I have any problems "internal" to SQL after the password is changed?
> Thanks for any tips.
> :)|||Nice one - thought that was it but always good to check.
Thank you.
Hari Prasad wrote:
> Hi,
> After the change you need to change the password for SQLServer Agent with
> new password.
> How to change the startup account:-
> 1. Control Panel - Admin tools -- Services
> 2. Double click above the SQLSERVERAGENT service
> 3. In the Log on tab, change the OS user name and enter the password, Click
> ok and restart the service.
> Thanks
> Hari
> SQL Server MVP
> "David Pounds" <david.pounds@.hohohohohohahahahahah.bum> wrote in message
> news:Oaib5H5VFHA.132@.TK2MSFTNGP14.phx.gbl...
>>Hi folks. Sorry if this one's a bit basic, but I'm a SQL 2000 novice.
>>I've just taken over responsability for some servers and I need to change
>>the domain administrator password.
>>I was wondering if changing this will have any adverse affects on SQL.
>>The SQL server is a domain controller. Only the SQLSERVERAGENT service
>>uses the administrator account.
>>Will I have any problems "internal" to SQL after the password is changed?
>>Thanks for any tips.
>>:)
>
>

Domain administrator password change

Hi folks. Sorry if this one's a bit basic, but I'm a SQL 2000 novice.
I've just taken over responsability for some servers and I need to
change the domain administrator password.
I was wondering if changing this will have any adverse affects on SQL.
The SQL server is a domain controller. Only the SQLSERVERAGENT service
uses the administrator account.
Will I have any problems "internal" to SQL after the password is changed?
Thanks for any tips.
Hi,
After the change you need to change the password for SQLServer Agent with
new password.
How to change the startup account:-
1. Control Panel - Admin tools -- Services
2. Double click above the SQLSERVERAGENT service
3. In the Log on tab, change the OS user name and enter the password, Click
ok and restart the service.
Thanks
Hari
SQL Server MVP
"David Pounds" <david.pounds@.hohohohohohahahahahah.bum> wrote in message
news:Oaib5H5VFHA.132@.TK2MSFTNGP14.phx.gbl...
> Hi folks. Sorry if this one's a bit basic, but I'm a SQL 2000 novice.
> I've just taken over responsability for some servers and I need to change
> the domain administrator password.
> I was wondering if changing this will have any adverse affects on SQL.
> The SQL server is a domain controller. Only the SQLSERVERAGENT service
> uses the administrator account.
> Will I have any problems "internal" to SQL after the password is changed?
> Thanks for any tips.
> |||Nice one - thought that was it but always good to check.
Thank you.
Hari Prasad wrote:
> Hi,
> After the change you need to change the password for SQLServer Agent with
> new password.
> How to change the startup account:-
> 1. Control Panel - Admin tools -- Services
> 2. Double click above the SQLSERVERAGENT service
> 3. In the Log on tab, change the OS user name and enter the password, Clic
k
> ok and restart the service.
> Thanks
> Hari
> SQL Server MVP
> "David Pounds" <david.pounds@.hohohohohohahahahahah.bum> wrote in message
> news:Oaib5H5VFHA.132@.TK2MSFTNGP14.phx.gbl...
>
>
>