Access Denied

Hi, i'm facing a problem, I have SQL Server 2000 instaled, the problem is when I try to connect using another computer, it can see the server, but when I try to connect i receive a Access Denied message. My TCP port is opened, and I can enter in the remote server using Query Analyzer, but I can't start the server using SQL Server Service Manager.

What is the problem?

Thanks.

Hi, I discovered what was wrong, I created a New Server Registration and added the remote computer on it.

Now everything is working fine.

sql

Access DB

I am trying to connect to an access database using Reportin Services 2000.
I can develop the reports just fine on my local computer, and I can get to
the file from the server. However, when I try to connect I get a path not
found error. I tried to connect with no username password and using admin,
but again I get an invalid path. So I tried to set up a DSN. It worked
just fine, but when I reference the ODBC drivers and the DSN I get no ISAM
drivers installed and path errors as well. I am logged into the machine as
admin and have full rights.
Any suggestions?
John WrightNevermind I found the problem.
John
"John Wright" <riley_wright@.notmail.com> wrote in message
news:%23pccxDtbGHA.4716@.TK2MSFTNGP03.phx.gbl...
>I am trying to connect to an access database using Reportin Services 2000.
>I can develop the reports just fine on my local computer, and I can get to
>the file from the server. However, when I try to connect I get a path not
>found error. I tried to connect with no username password and using admin,
>but again I get an invalid path. So I tried to set up a DSN. It worked
>just fine, but when I reference the ODBC drivers and the DSN I get no ISAM
>drivers installed and path errors as well. I am logged into the machine as
>admin and have full rights.
> Any suggestions?
> John Wright
>

Access 200 and MSDE 2000

Are there any known issues with installing MSDE 2000 on a computer that
already has Access 2000 installed?
No. Many people have been running Access and SQL Server on the same
computer for years. As long as you meet the minimum hardware and
memory requirements you should be fine.
--Mary
On Wed, 30 Jun 2004 13:12:40 -0500, "Mark Castelli"
<mcastelli98@.yahoo.com> wrote:

>Are there any known issues with installing MSDE 2000 on a computer that
>already has Access 2000 installed?
>
|||Many thanks
"Mary Chipman" <mchip@.online.microsoft.com> wrote in message
news:h6n8e01j5aopa7q2qkh6hlp5ih86l6bsus@.4ax.com...
> No. Many people have been running Access and SQL Server on the same
> computer for years. As long as you meet the minimum hardware and
> memory requirements you should be fine.
> --Mary
> On Wed, 30 Jun 2004 13:12:40 -0500, "Mark Castelli"
> <mcastelli98@.yahoo.com> wrote:
>

absolute path information is required

Hi all,
When i transfer my c#.net project to other computer,the report part of my project that worked correctly in my computer,did not work and give me this error :
"absolute path information is required"
what is my problem? i use access database for my reports
I try to create a blank report with no database,but i get this error again.
thanks for your help.Would you please send your code for loading, showing report.
I want to know, if you used untypedreport or typedReport,
WebApplication or windows application.|||public class ReportForm : System.Windows.Forms.Form
{
Thread waitThread;

ProgressBarForm pb;

private CrystalDecisions.Windows.Forms.CrystalReportViewer reportViewer;

private Reports.PulseReport pulseRpt = new Swiching.Reports.PulseReport();
private Reports.AllPulseReport allpulseRpt = new Swiching.Reports.AllPulseReport();
...
...
...

public ReportForm(string type)
{
InitializeComponent();
this.reportViewer.ReportSource = this.pulseRpt;
}

public ReportForm(string type,FileConnect.customer[] p,string bdLabel)
{
InitializeComponent();

waitThread = new Thread(new ThreadStart(wait));
waitThread.Start();
int temp;

TextObject beginRp = (TextObject)this.allpulseRpt.Section1.ReportObjects["beginRp"];
beginRp.Text = bdLabel;

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString =@."......Data Source=""Swiching.mdb""......";
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
conn.Open();
string ffirst = Config.GetNum("FirstNum");
string fcap = Config.GetNum("CapNum");

for(int counter = 0;counter < int.Parse(fcap);counter++)
{
temp = int.Parse(ffirst)+counter;
cmd.CommandText = @."insert into pulse values("+temp.ToString()+","+p[counter].city.ToString()+","+p[counter].intercity.ToString(+","+p [counter].national.ToString()+")";
cmd.ExecuteNonQuery();

}
conn.Close();
this.reportViewer.ReportSource = this.allpulseRpt;

}

private void wait()
{
pb = new ProgressBarForm();
pb.ShowDialog();
}

private void ReportForm_Load(object sender, System.EventArgs e)
{
pb.Close();
}

}

When i transfer my project to other computers and call ReportForm with each of above constructors i get "absolute path infomation is required" error.|||Hi.
Where do you load report? Is it typedReport?
I read your code. But I didn't understand where you set datasource of report. It seems you connect to database directlly.

I am sorry. I don't know reason. But you can examin
Initialize reportClass PulseReport in constructor, no difinition.
Try showing report without any datbase fields.
Trace code to find exact line of error
load report by using path, not instance of typedreportdocument.|||Try hardcoding the path into your connection string
Data Source=""Swiching.mdb""......";

should be

Data Source=""D:/anywhere/data/Swiching.mdb""......";|||Hi all and thanks for your reply

I add following code after InitializeComponent() :

crConnectionInfo.ServerName = Application.StartupPath + @."\swiching.mdb";
crDatabase = allpulseRpt.Database;
crTables = crDatabase.Tables;
for (int i = 0; i < crTables.Count; i++)
{
crTable = crTables [i];
crTableLogOnInfo = crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
rTable.ApplyLogOnInfo(crTableLogOnInfo);
}

Then I try to install my program on 6 computers and i found that only two computers have this problem and my report run correctly on other computers !!!
All computers have Windows XP SP2.

Dear zdehkordi ,i load report by following code in other form :

if(type == 1)
{
ReportForm rf = new ReportForm("AllPulse",p,bdLabel,edLabel);
rf.Show();
}|||Sounds like the directory structure is different on those two computers.
How does it differ from the others?
Are all the components in the right place?
Is Application.StartPath declared and valid?

about using osql BACKUP/RESTORE commands

Hi!
I'm using MSDE 2000 SP4 on local computer.
I backed up database into local hard drive using osql command like...
OSQL -E -Q "BACKUP DATABASE MYDB TO DISK = 'C:\MYDB.bak'" >
LogBackupDatabase.log
...and it's working fine. But when I try to save backup file directly
into network drive, it's not working. "LogBackupDatabase.log"-file
contains error message...
"Msg 3201, Level 16, State 1, Server MYLOCALCOMPUTER, Line 1
Cannot open backup device 'Z:\MyFolder\MYDB.bak'. Device error or device
off-line. See the SQL Server error log for more details.
Msg 3013, Level 16, State 1, Server MYLOCALCOMPUTER, Line 1
BACKUP DATABASE is terminating abnormally."
Z: is mapped network drive.
Is it possible to save backup file into network drive somehow? Maybe my
osql is not correctly formed to save into backup file into network
drive, or am I missing something?
Also restore command using osql is not working if I try to restore
backup file from network drive.
Thanks in advance!
Mika
Hi,
Use UNC (REMOTESERVER\SHARE\PATH\) path along with Backup or Restore
commands.
There are Few Pre requisites to do backup remotely;
1. You Should start SQL server using Domain user who got access to remote
machine Share
2. Should have share in the remote machine
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharenameX\dbname.bak' with
init
Perform the same for Restore Database
Note:
Backup to remote machine will not work if you start SQL server using Local
system account
Thanks
Hari
SQL Server MVP
"Mika M" <mahmik_removethis@.luukku.com> wrote in message
news:OASY$mStFHA.3452@.TK2MSFTNGP14.phx.gbl...
> Hi!
> I'm using MSDE 2000 SP4 on local computer.
> I backed up database into local hard drive using osql command like...
> OSQL -E -Q "BACKUP DATABASE MYDB TO DISK = 'C:\MYDB.bak'" >
> LogBackupDatabase.log
> ...and it's working fine. But when I try to save backup file directly into
> network drive, it's not working. "LogBackupDatabase.log"-file contains
> error message...
> "Msg 3201, Level 16, State 1, Server MYLOCALCOMPUTER, Line 1
> Cannot open backup device 'Z:\MyFolder\MYDB.bak'. Device error or device
> off-line. See the SQL Server error log for more details.
> Msg 3013, Level 16, State 1, Server MYLOCALCOMPUTER, Line 1
> BACKUP DATABASE is terminating abnormally."
> Z: is mapped network drive.
> Is it possible to save backup file into network drive somehow? Maybe my
> osql is not correctly formed to save into backup file into network drive,
> or am I missing something?
> Also restore command using osql is not working if I try to restore backup
> file from network drive.
> --
> Thanks in advance!
> Mika
|||hi,
Mika M wrote:
in addition to Hari valuable hint, please have a look at
http://support.microsoft.com/?id=283811 in order to modify the account SQL
Server and SQL Server Agent are running on...
unfortunately this article is no longer alligned with modifications applied
with sp4.. and you will no longer be able to start and run SQL Server and
the Agent only using the reported info..
I'm still trying troubleshooting it..
try "propagating" file permissions to all sub folders as described, as long
as assigning registry permissions as
HKLM\Software\Microsoft\MSSQLServer\Setup (READ)
HKLM\Software\Microsoft\MSSQLServer\MSSQLServer (FULL CONTROL)
for the account running SQL Server and
HKLM\Software\Microsoft\MSSQLServer\SQLSERVERAGENT (FULL CONTROL)
HKLM\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSo cketNetLib\LastConnect
(FULL CONTROL)
HKLM\Software\Description\Microsoft\Rpc\UuidTempor aryData (FULL CONTROL)
HKLM\Software\Microsoft\MSSQLServer\Setup (READ)
HKLM\Software\ODBC\ODBC.INI (FULL CONTROL)
for the account running the Agent...
make those accounts member of the local sysadmins WinNT role
but i definitevely hope kb article 283811 get updated..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

About the location of database file.

I can install the SQL Server Express in a computer and locate the database files in another computer of the same local network?

No, you cannot.

The datafiles have to be on a local drive -NOT a mapped drive, or even an UNC share. (A properly configured NAS/SAN is different though.)

about security

A lot of time the norton antivirus block an atemp to hack on my computer from an ip called himself nemo

the problem is that after the installation of MSSEE with advanced service I found that the mssee want to connect to a server called nemo and that the admin name is nemo

so whatthat suppose to mean?

ahere is a part of the log file:

Opening 'MachineConfigScope' for [NEMO]
Trying to find Product Code from command line or passed transform
If possible, determine install id and type
Trying to find Instance Name from command line.
No Instance Name provided on the command line
If possible, determine action
Machine = NEMO, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = NEMO, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = NEMO, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)

Moving to SQL Security forum.|||

I am so sorry I discovered that the system name of my computer is nemo

so the mssee is secure

I am aufully sorry

youssef

about multiple clients

I have a sql server application program developped with ODBC. The program can
run at different computer and realize synchronization operation. But
sometimes it has error message :
"Attemp to scroll past end or before beginning of data".
Could you tell me the reason ?
it seems the program got failure when trying to find next row, but the
position may not point to an valid row,since the row could be deleted by
other process from another machine.

about multiple clients

I have a sql server application program developped with ODBC. The program ca
n
run at different computer and realize synchronization operation. But
sometimes it has error message :
"Attemp to scroll past end or before beginning of data".
Could you tell me the reason ?it seems the program got failure when trying to find next row, but the
position may not point to an valid row,since the row could be deleted by
other process from another machine.