Groups: Member
Joined: 12/19/2009
Posts: 100
Rank:
 (1299)
|
Hello
I had a client and server working perfectly but had to replace the hard drive in the server. However for some reason I now cannot get the client to connect to the server.
Both are on Win 7 and on a home group with the same username and apssword and SQL file added with printer and file sharing. I can see all the folders across both PCs but am now stuck.
I have managed to get the CM software to open on the client and connect to the database but when i open media center it says it cannot connect to the databse
can someone help please?
also if i cannot get this to work is there anyway i can copy the sharing permissions from my old drive to the new? I have installed a new SSD to cloning the entire hard drive was not an option.
|
Groups: Member
Joined: 1/2/2009
Posts: 21
Location: Central Ohio, USA
Rank:
 (3323)
|
try turning off the windows firewall on both machines and see if you can connect. If you can then you need to set up a firewall rule.
To create the firewall opening for SQL, copy the following into notepad and save it as sql firewall.bat Then run the bat file on both computers as an administrator.
@echo ========= SQL Server Ports ===================
@echo Enabling SQLServer default instance port 1433
netsh firewall set portopening TCP 1433 "SQLServer"
@echo Enabling Dedicated Admin Connection port 1434
netsh firewall set portopening TCP 1434 "SQL Admin Connection"
@echo Enabling conventional SQL Server Service Broker port 4022
netsh firewall set portopening TCP 4022 "SQL Service Broker"
@echo Enabling Transact-SQL Debugger/RPC port 135
netsh firewall set portopening TCP 135 "SQL Debugger/RPC"
@echo ========= Analysis Services Ports ==============
@echo Enabling SSAS Default Instance port 2383
netsh firewall set portopening TCP 2383 "Analysis Services"
@echo Enabling SQL Server Browser Service port 2382
netsh firewall set portopening TCP 2382 "SQL Browser"
@echo ========= Misc Applications ==============
@echo Enabling HTTP port 80
netsh firewall set portopening TCP 80 "HTTP"
@echo Enabling SSL port 443
netsh firewall set portopening TCP 443 "SSL"
@echo Enabling port for SQL Server Browser Service's 'Browse' Button
netsh firewall set portopening UDP 1434 "SQL Browser"
@echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
netsh firewall set multicastbroadcastresponse ENABLE
|
Groups: Member
Joined: 12/19/2009
Posts: 100
Rank:
(1299)
|
Hello
Thanks for your reply and I tried what you suggested and it worked. However how do I run a bat file.
I opied the text into text document (assume this is the same as notepad) and renamed as you suggested. Stupidly i thought I would then be able to double click the file to run it.
Can you please tell me how to run a bat file in wondows 7
many thanks
|
Groups: Member
Joined: 10/19/2009
Posts: 292
Location: Chesterfield UK
Rank:
(4608)
|
martint999 wrote:Hello
Thanks for your reply and I tried what you suggested and it worked. However how do I run a bat file.
I opied the text into text document (assume this is the same as notepad) and renamed as you suggested. Stupidly i thought I would then be able to double click the file to run it.
Can you please tell me how to run a bat file in wondows 7
many thanks You need to right click on the file and then select Run As Administrator
|
Groups: Member
Joined: 12/19/2009
Posts: 100
Rank:
(1299)
|
That worked perfectly thanks. However when I try to play a movie media player says it cannot find the location.
However if I remapp the film to what looks like the same location it works. Now this all started as I completed a new windows install and Restored my CM database from a back up. Any idea why it won't work on the original file path but will work when I remap to what looks like the same location?
If I have to consider remapping I've 600 movies is there a batch way this can be done?
Thanks for the help thus far.
|