Filed under: MS SqlServer | Tags: Remote Connection, Remote Login, SQL Server Connection, SQL Server Remote Login
When i was migrated to SQL Server 2005 from 2000, I faced some technical problems. I could not able to connect the server remotly after installing the default setting. Even i could not connect the SQL server from the Visiual Studio. All the cases the system prompt that the remote connection did not enable or server does not exit. But by default SOL server remote connetion is enable.
I did some special task to resolve the problem that are listed belows,
1. Creating windows firewall exception for SQL server port(Default 1433) and SQlSERV.exe. Before that check your SQL server listening port number from Logfile( “C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\LOG\\ERRORLOG”).
2. Surface area Configuration
a. Select Start Menu>SQL Server 2005>Configuration Tools>Surface area Configuration
b. Click Serface area Connection
c. Select Using Both TCP/IP and named piped
d. Apply
3. Network Configuration
a. Select Start Menu>SQL Server 2005>Configuration Tools>Server Configuration Manager
b. Click Nenwork Configuration
c. Select Protocol for SQL Server
d. Enable TCP/IP
Thanks
Khayer
GIS Programmer, CEGIS
Bangladesh
Filed under: Crystal Report | Tags: Could not load file or assembly 'CrystalDecisions.Windows.Forms, Crystal Report 2008, Crystal Report in .NET 3.5, Version=10.5.3700.0
I have to pass a terrible day for deploying a project where Cystal Report is used. I have used Install Shield 15 to make the installer of the project. Project is installed to client pc hopefully, But when the user click the report generate button, System triger following error,
<code>Could not load file or assembly ‘CrystalDecisions.Windows.Forms, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304′ or one of its dependencies. The system cannot find the file specified.
</code>
Program does not find the assembly for generating report in the client PC. When i build the installer, Version =10.2.3600 is used which wrong. You can check it go to below directories,
C:/Windows/Assembly/
Now Solution, I have to spend the whole day for the solution, though i am experience in deploying web project of .NET 2.0 which use Crystal Report. Bussiness solution web site is one the complecated site in the web to me. It seems to me useless. Furtuantlly Microsoft forum help to solve the problem. I have to install CRRedist2008_x86.msi in the Client PC to get desires assemblies. i have got the file in my development pc in following dirrectory,
C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\CrystalReports10_5
Then, at the end of the day i feel very relieve. Thanks Mirosoft foum.
Thanks
Khayer
GIS Programmer, CEGIS
Bangladesh
Error: Access denied
It is very common experience to every developer when he/she host a file uploader page. Interestingly developer does not face this error in development PC.
The main reason of this problem is security issue of the host computer. Host pc does not allow write operation of IU or Guest user. But IU and guest user need write acces of upload folder in host pc.
the solutin if not very stadartd considering sercurity. folloe the belows steps,
1. enable write access of virtual directory of the page using IIS(default value of write access is unchecked )
2. Right write click uploading folder of the site. In the security tab provide write access to Users, Internet Guest Account.
3. Complete
The main disadvantage of this technique is the security. Write access of IU user some time vulnerable. so, alternatively your can use database to store file instead of file system.
Thanks
Khayer
GIS Programmer, CEGIS
Bangladesh
